The solution I have always used that has never let me down, is simply to use the name of the month in date rather than the number, then they are always in the right format.
So mydate = "12/feb/2004" CreateODBCDateTime(mydate) Russ > -----Original Message----- > From: Sam Clement [mailto:[EMAIL PROTECTED] > Sent: 16 April 2004 14:58 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] localization > > > Does anyone have any links/advice regarding CF localization? > > I'm having problems inserting UK dates into an access database (CFMX > 6.1) > > I'm using setLocale to and lsdateformat to validate user > input but when I insert these dates into the access db - > createODBCDate(#datevalue#) - the months and days get messed > up in a seemingly random manner. > > Seems like a problem that has an easy solution but I haven't > been able to find it. > > It will be hosted on a US server. > > Cheers, > > Sam Clement > ABOVE Studios > Boutique Design Solutions > 7 Sunny Place - Cascade > Trinidad + Tobago - West Indies > T: (868) 621 3626 W: abovestudios.com > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
