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.