Are there any date issues (particularly Y2K issues of all things) with CF5 compared to
CFMX?
Here's the situation:
We have an app which we will be porting over to CFMX. Our QA server is currently on
CF5. We have a search screen that lists patients and their date of birth (among other
things). The search results are displayed using XML. The record is being passed with
date_of_birth="#dateformat(date_of_birth, 'mm/dd/yyyy')#"
On CFMX, the DOB is displayed as 10/02/1929 (as it should be). However, on CF5, it
comes out as 10/02/2029. This seems to be true for all birthdates prior to 1930.
Putting the query into Toad (this an Oracle database), shows that the data is coming
out with the proper year (4-digit format).
This issue isn't listed in the Migrating from CF5 documentation, but I'm curious if
anyone has seen this?
Thanks!
Scott
--------------------------------
Scott Brady
http://www.scottbrady.net/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
