Date format

[Peter Kinsman]

I am in the UK, so my native date format is dd/mm/yy.
I have a query that selects transactions by date, so I normally use
TranDate = # & Format(FormDate, "mm/dd/yy") & #
and it works - until 6th January 2009, when I had to remove the Format
function to select any records.
Can anyone explain please?

Many thanks

Peter Kinsman

 

[Stefan Hoffmann]

hi Peter,

I am in the UK, so my native date format is dd/mm/yy.
I have a query that selects transactions by date, so I normally use
TranDate = # & Format(FormDate, "mm/dd/yy") & #
and it works - until 6th January 2009, when I had to remove the Format
function to select any records.

For operations with Date/Time values in Jet SQL you always have to use
the US format regardless of your local date/time format in Windows, e.g.

TranDate = Format(FormDate, "\#mm\/dd\/yyyy hh\:nn\:ss\#")



mfG
--> stefan <--