I'm having a problem inserting the date into access.
My access field is formatted as mm/dd/yyyy.
This is what I have in my asp page.
dtToday = Date()
objRS("Date") = dtToday
Then I get this error message.
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Anybody know what i'm doing wrong.