[Solved] Query Selecting date range
Posted: Tue Dec 08, 2009 3:35 am
I am having problems with my query language. I am trying to select a certain date range using a query.
BASE returns the following error message:
Thanks!
Oldnilene
I am using the date format of mm/dd/yyyy. I have also tried the format of dd/mm/yyyy and neither work.SELECT "Date Request" FROM "Donation Assignment" WHERE "Date Request" <= #03/11/2009# AND "Date Request" >= #03/07/2009#;
BASE returns the following error message:
Any ideas of how to complete this query successfully??Syntax error in SQL expression
Thanks!
Oldnilene