date format switch problemin SQL Server/Access

[Guest_imported]

I have experienced the same problem in both Access and SQL Server 2000.
Using the UK date system <%Session.LCID = 2057%>
things are fine until the day matches the month (ie: 2nd Feb, 12th Dec). After that, the day and month are switched whenever a record is added or amended.
I remember seeing something about this on the MS support site months ago, but have been unable to relocate it.
Any ideas?

 

[tlbroadbent]

By default, Access and SQL server use the &quot;American&quot; date format, mdy. You can inform SQL Server that you want to use a different format with the SET DATEFORMAT command. Then insert or update the date in the table. See SQL BOL for more info on SET DATEFORMAT.

SET DATEFORMAT dmy
Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm