Strange results querying dates

[Rikshapa]

Hi All,

I'm getting strange results when querying dates with SQL using DAO with Jet 3.5

SQL like: SELECT * FROM [Invoices] WHERE [Date]>=#02/10/2004# AND [Date]<=#01/11/2004#, gives good results when the system date format is set to MM/dd/yyyy but fails when setting the format to dd/MM/yyyy.

the dates in the query are changing dynamically to fit the system formats (02/10/2004 changes to 10/02/2004 etc...) so the query should work in both cases but it seems like the Jet 3.5 engine is not sensitive to locale settings ???

Any clue ?

thanks,

Rikshapa.

[TheCPUWizard]

Been a while since I used Jet 3.5, but from memory it does NOT respond to locale. :cry:

[Rikshapa]

This is the answer. Jet 3.5 forces the: MM/dd/yyyy format. (checked)

Thanks a lot,

Rikshapa