SQL and Date Formats
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 ?