Access reversing dates

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
 
N

Newbie

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
 
Top