I have a field that is set as a date/time field in MSAccess. When I try to query it using ASPRunner, I get the following message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/db_apps/performance_totals/Performance_All_list.asp, line 470
The only time I do NOT get this message is when I do a query where the date field "contains" a value. I am interested in querying for information between two values in an advanced search.
Should I be using some wildcards or something to offset the dates?
