date format in Access 2002

[hpaille]

I use the following query that returns all my subscribtions with an end date greater than the 1st of June:
SELECT Abonnements01.*
FROM Abonnements01
WHERE (DATE_FIN>#06/01/2004#');

However, if I do the same for the 28th of Feb, the following query also works:
SELECT Abonnements01.*
FROM Abonnements01
WHERE (DATE_FIN>#28/02/2004#');
--> the format is different. How is it chosen (fairly obvious for the 2nd example, but for 01/06 or 06/01 ???)

I tried with "format(28/02/2004, 'mm/dd/yyyy')", and it worked !

How can I be sure that Access is using the format I want ?

 

[PHV]

It's a trial'n'error scheme with m/dd/yyyy preference when ambiguity.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

By using an obvious format knowing that m/d/yyyy is preferred when ambiguity.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244