Access 2000 and Dates going wrong

[joolzzz]

Hi,

Can anyone tell me how to fix my date problem in MX2004 and Access 2000. I
have a table where I am trying to only get records of a certain date which
works for dates such as 31/01/2005 but not for 01/01/2005. I think this is
because the system gets the date format mixed up in my SQL. How can this be
fixed so the SQL looks for dates in access in UK and does not get confused buy
the 01/01 bit..

I hope this is clear, and tanks for any help.

Joolz

[Julian Roberts]

It might be better to pass dates to your query in the standard ISO format of
YYYY-MM-DD. This is unequivical, the database won't get confused about what
date it is. You could also pass the date as eg 17-March-2005. Although, this
might not work on French servers, for example

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004