Date/Time - Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[theflyingminst]

Hi I am getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

This is my SQL statement (goDate is in 2/15/2009 format. I'm thinking that might be my problem?.. It IS a date/time field in Access).

SQL = "insert into calendar (event, cal_date, username) values " & _
"('" & new_event & "','" & goDate & "','" & my_usernm & "');"


Thank you

[chazzy]

it is. you have to use something to convert the string (since SQL is a string when you build this variable it becomes a string) to a date. Try using CDate.

[Charles]

Give #2/15/2009# a try.

[theflyingminst]

Hi, #2/15/2009# worked. Thank you!