Re: US vs UK date format

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.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ianc" <ianc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC2A8963-47CB-4603-A9D0-5AEDE5C2E33C@xxxxxxxxxxxxxxxx
> 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


.

Relevant Pages

  • Re: Date format problem
    ... matching actually take place the double numbers date are automatically return ... > International Date Formats in Access ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.modulesdaovba)
  • Re: europe date format / input mask
    ... International Date Formats in Access ... input masks on date fields are about as useful dinosaur repellent. ... rather than allenbrowne at mvps dot org. ... > I change the format property as dd/mm/yy and this let me see the date as ...
    (microsoft.public.access.forms)
  • Re: Setting Report Filter
    ... That should not stop the query from reading it though. ... rather than allenbrowne at mvps dot org. ... these are the only formats that are available for text boxes. ...
    (microsoft.public.access.reports)
  • Re: Macro behaves differently then when recorded and stuffs dates (or date formats)
    ... The implications of VBA trying to arbitrate dates by reference to your ... The good workaround is to use non-ambiguous date formats in all contexts. ... > software assume English if I have regional settings of English ...
    (microsoft.public.excel.programming)
  • Re: conditional number formats for y-axis labels
    ... If you're using VBA anyway to set the axis scales, it's a matter of adding one or two lines to set your number formats. ... (Thanks to previous posters and Jon Peltier for help with that!) ... I would now like to dynamically set the number format for the tick mark labels. ...
    (microsoft.public.excel.charting)