Date format

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
 
S

Stefan Hoffmann

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.
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 <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top