I think it expects the date in the format the servers date settings are set.
LS Locale Specific.

DateFormat expects the US format if I am correct... Could be wrong...
I always use CreateDate()


-----Original Message-----
From: Barry Beattie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 7 July 2004 3:59 PM
To: CFAussie Mailing List
Subject: [cfaussie] CF & Dates - something's gotta give!



[error]"1989/01/31" is an invalid date format.

since when? it's the ISO standard*. So what's wrong with this?
<cfset args.data.DOE = LSDateFormat("1989/01/31","yyyy/mm/dd") />
(big fat error)

but this format is fine
<cfset args.data.DOB = LSDateFormat("4/11/1976","yyyy/mm/dd") />

and so is this (except it still confuses dmy with mdy)
<cfset args.data.DOD = DateFormat("2004/04/04","yyyy/mm/dd") />

so what gives? Why does LSDateFormat() throw an error on the ISO format
when DateFormat() doesn't?

I'm not really looking for a solution ATM - I'll decide on a format and
apply that or do what everyone else does and tear it apart just to piece
back together. I'm just venting my spleen over illogical-ness and the
lack of support in CF for a drop-dead simple format - yyyy/mm/dd. Even
ASP would happily accept the ISO date standard and carry it from FORM to
DB without mistake.

I bloody well hope CF7 has got it's dates all sorted.
It's giving me the sh!+s

hrrrmph!
barry.b

* http://www.iso.org/iso/en/prods-services/popstds/datesandtime.html


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Register now for the 3rd National Conference on Tourism Futures, being held in 
Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to