hello
i have a textbox in the form load i write
Format$(time, "hh:mm:ss").
when i insert this in the database(SQL Server7)
insert this 1/1/1900 12:30:55 actual hour
what is the problem????
Printable View
hello
i have a textbox in the form load i write
Format$(time, "hh:mm:ss").
when i insert this in the database(SQL Server7)
insert this 1/1/1900 12:30:55 actual hour
what is the problem????
check the format of the field in the database you are saving it to. It would have to be the same as the textbox format.
In a format string, 'm' is for months. Use 'n' for minutes like so:
Format$(Now, "hh:nn:ss")
Paul