Date format : field set to dd/mm/yyyy, but query wants mm/dd/yyyy

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

On w2000 I have local date settings to dd/mm/yyyy
In Access2000 the field dormat I have same settings.
However in a query I have to use mm/dd/yyyy otherwise it finds no matches
and return an empty recordset.
Is this normal?
If not, how do I fix it?
 
Yes, it is normal. Access expects dates to be in mm/dd/yyyy format,
regardless of what the short date format has been set to. (Actually, it'll
accept any unambiguous format, such as yyyy-mm-dd or dd-mmm-yyyy. The point
is, it will treat dd/mm/yyyy as mm/dd/yyyy for days of 12 or less.)

You can easily get around this by explicitly formatting your dates in
queries (see http://www.mvps.org/access/datetime/date0005.htm at "The Access
Web" for one suggestion)

You might also find Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html to be useful.
 
Back
Top