The SQL that is sent to the database engine as a DATE, must be in 'YYYY-MM-DD'
Either of the SQL below will work:
- Code: Select all Expand viewCollapse view
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'
I hope this helps, please be sure to let me / us know.
Thanks to add [Solved]
in your 1st post Subject (edit button top right) if this issue has been resolved.