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
 
Back
Top