US/UK dates problem



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

.



Relevant Pages