I have a problem inserting dates in a MS Access database. Days and month are swapped everytime the date stay valid Ex: 05 of june 2013 become six of may 2013 but 13th of june is not changed.
I use #CreateODBCDate(Dateformat(mydate,"dd/mm/yyyy"))#
Of course i put in my Application.cfm : <cfset Locale=setLocale("French (standard)")>
Windows 2003 server and CF8.
Sorry for my terrible english and thanks in advance.