I need to write a query that will be delivered via ASP to a MS Access table.
This is what I have tried:
select ordernumber from logsearch where ordernumber='2n2222' AND searchdate>11/1/2014
The field searchdate is setup as a datetime field.
The query does not discriminate by date.
I've tried surrounding the date with #, ', and " to no avail.
What am I missing?