European Date Stored in DB

[HedgeKAM]

My date fields in my db are stored in dd/mm/yyyy format. Using VBA I can manipulate it fine, but problems arise when doing things like this:

SELECT * FROM Table1 WHERE EuroDate < #01/01/2004#

Is there a way to format EuroDate with SQL? (Im doing this in a query, so I cant use VBA.

Thanks in advance for any help!

 

[Rich]

SELECT * FROM Table1 WHERE EuroDate < Format(#01/01/2004#,mm/dd/yyyy)