hi everyone,
Just installed CFMX and while almost everything seems to be working ok I've
come across a major problem when using lsParseDateTime.. it can no longer
parse dates and times outside of a certain java format.
eg. I was once able able to pass these times and they'd be converted to
datetime format.
CF5.0 and previous:
1/7/2002 11:59 pm = {ts '2002-07-01 23:59:00'}
1/7/2002 11:59:00 pm = {ts '2002-07-01 23:59:00'}
1/7/2002 11:59pm = {ts '2002-07-01 23:59:00'}
1/7/2002 11 pm = {ts '2002-07-01 23:00:00'}
1/7/2002 11pm = {ts '2002-07-01 23:00:00'}
1/7/2002 11.00 pm = {ts '2002-07-01 23:00:00'}
With CFMX I get this:
1/7/2002 11:59 pm {ts '2002-07-01 23:59:00'}
1/7/2002 11:59:00 pm - COULD NOT PARSE
1/7/2002 11:59pm - COULD NOT PARSE
1/7/2002 11 pm - COULD NOT PARSE
1/7/2002 11pm - COULD NOT PARSE
1/7/2002 11.00 pm - COULD NOT PARSE
Taking a look at the CF5.0 documentation and using the example supplied for
parsedatetime I got these results with CF5:
8:30:00 = {ts '1899-12-30 08:30:00'}
20:30:00 = {ts '1899-12-30 20:30:00'}
January 25, 1999 8:30:00 = {ts '1999-01-25 08:30:00'}
8:30:00 Jan. 25, 1999 = {ts '1999-01-25 08:30:00'}
1/25/1999 8:30:00 = {ts '1999-01-25 08:30:00'}
But with MX:
8:30:00 = {ts '1899-12-30 08:30:00'}
20:30:00 = {ts '1899-12-30 20:30:00'}
January 25, 1999 8:30:00 = COULD NOT PARSE
8:30:00 Jan. 25, 1999 = COULD NOT PARSE
1/25/1999 8:30:00 = COULD NOT PARSE
Rather than reinvent the wheel (and rewrite hundreds of lines of code then
retest our currently functioning systems), I'd like a function that would
work just like lsParseDateTime v5.0. Is there a custom tag or function
available that will do this?
Thanks,
George
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
