US vs UK date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using the following filter in a form "[OLP Call Date] = #05/07/2005#" and
all date formats are set to UK. However the results show data for the 7th
May 2005. How do I get them to show the 5th July 2005
 
Also when I use the filter "[OLP Call Date] = #13/07/2005#" I get the correct
data for the 13th July 2005 !
 
See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

The article explains that literal dates in VBA and SQL statements are
interpreted as US, whereas date values entered into the interface are
interpreted by your regional settings, and explains how to avoid the 3 cases
where Access is likely to misunderstand your dates.
 
Thanks very much Allen. Your site was a great help - problem now solved.

Ian

Allen Browne said:
See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

The article explains that literal dates in VBA and SQL statements are
interpreted as US, whereas date values entered into the interface are
interpreted by your regional settings, and explains how to avoid the 3 cases
where Access is likely to misunderstand your dates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

ianc said:
I'm using the following filter in a form "[OLP Call Date] = #05/07/2005#"
and
all date formats are set to UK. However the results show data for the 7th
May 2005. How do I get them to show the 5th July 2005
Click to expand...
Click to expand...
 
Back
Top