ANY BODY HELP ME!!!!!!

   I HAVE A PROJECT AND IN A FORM I HAVE THREE TEXT BOXES.ONE FOR THE CUSTOMER NUMBER,ANOTHER FOR DATE,TIME.CUSTOMER NUMBER WILL BE INSERTED AUTOMATICALLY.BUT I WANT THE DATE AND TIME TO BE THAT OF THE SYSTEM DATE AND TIME.WHAT CODE SHOULD I USE IT TO ACCOMPLISH IT?
THIS PROJECT IS AN URGENT ONE.SO I HAVE TO COMPLETE IT TODAY ITSELF.SO,PLEASE HELP ME URGENTLY........
     NANDA KUMAR
  [email protected]

hi,
you could try Date & Time. do you have the code that inserts customer nu mber automatically?

vbscript
text box
MsgBox CStr(Date)

or to a log file
objFile.WriteLine Date

No.I have connected it to the Database.Thanks.

Do you have the code for the insertion of Date and Time into two text boxes...If yes, then please give.I will be very thankful to you..

GIve me a reply anybody.....pls

' Displays the date
Me.TextBox1.Text = DateTime.Now.ToShortDateString

' Displays the time
me.textbox1.text = datetime.now.ToShortTimeString

Will the below code work? I tried it, but not coming properly.

Which version of Visual Basic do you use?

Tested with version 2005.net, works fine?!

I am working with VB Version 6.

 Nanda Kumar

In vb6.0 use this (any one, which you need)
MsgBox FormatDateTime(Now, vbShortDate)
MsgBox FormatDateTime(Now, vbGeneralDate)
MsgBox FormatDateTime(Now, vbLongDate)
MsgBox FormatDateTime(Now, vbLongTime)
MsgBox FormatDateTime(Now, vbShortTime)

To use just system date
msgbox Date

when you need, just the system date to be inserted,
dim s as string
s = cstr(date)
use s in your insert sql statement by concatenating it in the proper field place.

hope this helps.

With Regards,
Raghavendra Mudugal

Thankz.

How can we get back the datas written into the DB,into a form?
I was unable to do it.How can we create a Pop-up Calendar in VB?



Nanda Kumar