I have a table which contains dates in the format of dd/mm/yyyy.
I have a field on a form with a date format of dd/mm/yyyy.
If i try to reference the two together via sql, with the Form field value of 14/03/2002 SQL will treat this value correctly and understand it as 14th March 2002.
However, if the value is 12/03/2002 SQL will understand it as 3rd December 2002.
Clearly SQL's default date format is American Standard.
What can I put in my SQL to force it to run as dd/mm/yyyy ?
Thanks

View the article at the following link:

http://www.flws.com.au/showusyourcod...te.asp?catID=3

There is also a work around. SQL and Access store date formats as mm/dd/yyyy. If you pass the values to SQL or Access as dd/mmm/yyyy then all is fine.

HTH,

Beth M

You should use the ISO format: yyyy/mm/dd. This way, you won't have any problem. Also read this topic http://p2p.wrox.com/topic.asp?TOPIC_ID=3144


Stéphane Lajoie

Allen Browne also has some information regarding date formats:

http://users.bigpond.net.au/abrowne1/ser-36.html

Regards,

Beth M