I have had more than this much trouble with ASP doing the same. It's a middleware to DB problem not language specific. Have you tried the createODBCDate() function?
-----Original Message----- From: Salvatore Fusto [mailto:[EMAIL PROTECTED] Sent: 07 July 2004 14:40 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] LS date woes - any ideas? hello, i fill the date form fill as dd/mm/yyyy, i.e. 01/03/1996, then pass this field to database. when i retreive the value from database, i set the fiels LSdateFormat(#date_var#,'dd/mm/yyyy') which displays 01/03/1996, supposing date_val contains the date best regards salvatore ----- Original Message ----- From: "Barry L Beattie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 07, 2004 1:12 PM Subject: [ cf-dev ] LS date woes - any ideas? > Hi all > > I've been bitten with CF's rejection of the ISO date format with LSDateFormat and general grief with non-US dates (esp with dd/mm/yyyy). The idea is simply to pass a date from a form to a cfqueryparam in ISO format without grief. I'm not winning. > > "invalid date format" LSDateFormat("1996/01/03","yyyy/mm/dd") > > Apart from tearing the date apart and re-assembling it or using "mmm" for months, is there anything else that consistantly works? > > I never had this much grief with ASP (when I used the ISO format). > > cheers > barry.b > > > > > > > > > > -- > _______________________________________________ > Talk More, Pay Less with Net2Phone Direct(R), up to 1500 minutes free! > http://www.net2phone.com/cgi-bin/link.cgi?143 > > > > > > -- > 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] -- 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]
