|taiseux||-- 06-12-2013 @ 10:22 AM|
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.
|taiseux||-- 06-17-2013 @ 5:32 AM|
Someone gave me the answer so i post-it here if somebody has the same problem :
and for insertion in the db :
<cfqueryparam value=#variables.dateObject# cfsqltype="cf_sql_date">
and no more false interpretation with dates with day under 13.
|EasyCFM.COM ColdFusion Forums :||http://archive.easycfm.com/forums|