Hi,

I'm getting crazy with such simple thing...

I'm using:

wdate = Format(MskDate.Text, "dd/mm/yyyy")

wSQL = "UPDATE Customers SET DateExp=" & wdate & " WHERE CodeUser='TEST'"

but it records the date in my table as "01/01/1900"

Why?

I also tryed to use # in the update statement, but no success...

-----------------------------------------------------------------------

I also tryed:

MskDate.Text = "15/10/2002"

wSQL = "Update CUSTOMERS Set DateExp = MskDate.Text Where CodeUser='TEST'"

This is the error message:
"The conversion of char data type to smalldatetime data type resulted in a out-of-range smalldatetime value"
-----------------------------------------------------------------------

Note: I'm using SQL 7 and smalldatetime data type.


Thanks for any help...

Michel Junior