Re: US/UK dates problem

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

The article explains how Access uses your Regional Settings in the
interface, but expects the American format delimited with # for literal
dates in SQL statements and VBA. Also identifies 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.

<paulquinlan100@xxxxxxxxxxx> wrote in message
news:1151672233.287292.230860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I've just started having some problems with my coded queries. They had
been working fine but all of a sudden they seem to have started needing
US style dates eg mm/dd/yyyy.

When i build a query using the designer i can enter UK dates and it
works fine, however, if you look at SQL view it has actually changed
them to US style dates.

I dont think the system date could have changed as its a work computer
and we dont have access to the control panel....

Any ideas.
Thanks a lot
Paul


.

Relevant Pages

  • Re: dynamic type checking - a pauline conversion?
    ... >> defined in an interface, if they dont, then my original point applies. ... > Paul C wrote: ... > "If they dont share any commonality then then surely there is ... If there is no interface overlap then you have to explicitly switch on object type ...
    (comp.object)
  • Passing arrays from VB6 to C# ActiveX
    ... dont get the list of availbale member functions in VB but the code WORKS. ... getting the following error message "Function or interface marked as ... Use in the declaration in C# code. ... The type library file looks ...
    (microsoft.public.dotnet.framework.interop)
  • Re: sun gigabit ethernet (ge) issues
    ... number of stats coming across the interface. ... >> We've been seeing some weirdness on one of our nfs clusters with ... We dont see any evidence of the issue on our switches. ... Justin Shaffer ...
    (comp.sys.sun.hardware)
  • Re: Postfix, "From:" address, command line
    ... > I sometimes send mail through command line interface this way: ... But i really lost the file name, and dont know if it ... You could inject the mail using postfix's injection program. ...
    (Fedora)
  • Re: DNS issues after creating a child Zone
    ... Only reason i use the web based thing is i cant access NG from work ... NG but since they changed the interface and split the groups up all ... dont know if u remeber but you helped me a few times back then must be ...
    (microsoft.public.win2000.dns)