Barry
Couple of questions, firstly have you set the locale appropriately e.g.
Tried setLocale("English (UK)") with the date in dd/mm/yyyy form?
Also what version of cf are you using?
Finally most problems I have come across with dates involve using date
functions against string representations of dates as opposed to *actual
date time objects* created using createDate, LsParsedateTime etc. Try
converting it into a valid date time object using one of the date
related functions. If you are on cfmx you can wrap the function call in
cfcsript in try/catch (incase the user enters "kentucky fried chicken
instead of a date"). Beware the unpredictable/unreliable isDate()
function.
HTH
KOla
is
>> -----Original Message-----
>> From: Barry L Beattie [mailto:[EMAIL PROTECTED]
>> Sent: 07 July 2004 12:12
>> To: [EMAIL PROTECTED]
>> 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]
