US/UK dates problem

[paulquinlan100]

Hi

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

[Allen Browne]

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.

<pa************@hotmail.com> wrote in message
news:11**********************@h44g2000cwa.googlegr oups.com...

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

[paulquinlan100]

Thanks a lot Allen, i could have spent hours trying to figure that
out... seems slightly ridiulous that thats the case though
Allen Browne wrote:

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.

<pa************@hotmail.com> wrote in message
news:11**********************@h44g2000cwa.googlegr oups.com...

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