datestamp field?

Hi,

I try to insert a record from VB6 to the SQL server 2005 and have a problem when put Now() into the field on the SQL server which defined as datestamp field type.

Could any one help?

Thanks!

Now() returns Date+Time so you may try using Date() function instead or Format(Now, "mm/dd/yyyy")...

Or ... you can assign default value for that field directly in your database so you wouldn't have to include this field in your Insert statement.

can you please post some code?
What error have you come accross?

:wave: