Access reversing dates

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Help please

I have a date field on a form dd/mm/yyyy this date is passed into a sql
string and for some reason the date changes to mm/dd/yyyy and as all
records are dd/mm/yyyy the results are not as expected

Any advice will be gratefully received

Cheers

Paul
 
Try explicitly formatting the date in your SQL strings. This is the SQL
sees the dates correctly . . .

jetdatefmt = "\#mm\/dd\/yyyy\#"

Format$([datefield], jetdatefmt)

HTH
 

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

Similar Threads

Formatting date gives bad results in query 2
Date Function in query 3
calculate Age problem date notation european american format 2
convert a date 4
Changing date format 2
Date format in query export. 4
Peculiar date problem 1
query on date 1

Back
Top