The SQL that is sent to the database engine as a DATE, must be in
'YYYY-MM-DD' format.
Either of the SQL below will work:
Code: Select all
SELECT "Date Request" FROM "Donation Assignment" WHERE "Date Request" <= '2009-03-11' AND "Date Request" >= '2009-03-07'
SELECT "Date Request" FROM "Donation Assignment" WHERE "Date Request" BETWEEN '2009-03-07' AND '2009-03-11'
Now, if you are creating your Query with the Base GUI ( Graphical User Interface ) . . . for example, from
Create Query in Design View... . . . Base will parse the Query first, and, modify a Date on the Criteria line based on the user's Language Settings, to a format used by your database engine (
'YYYY-MM-DD' ). But, if you are 'sending' this SQL directly to the database engine ( for example from a Macro, or, with
Run SQL command directly you must code the date in
'YYYY-MM-DD' format.
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add
[Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.