Date format

  • Thread starter Thread starter Peter Kinsman
  • Start date Start date
P

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
 
hi Peter,

Peter said:
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.
Click to expand...
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 <--
 
Back
Top