Inserting Date values in Access 2000
Posted on 2002-05-31
I have an Access 2000 database with a table that has a number of Date/Time fields in it. Each field is set to format Short Date.
When in Visual Basic 6 I try and Insert a row into the table, I use the Execute method of an ADO connection object to run an in-line SQL statement. The Dates which are to be entered are all in correct Short Date format. The row is entered but all the Date/Time fields all show their value as 30/12/1899.
Why is this?
How come the correct date from the SQL statement aren't saved?