I'm having some issues with the display of date format. The recordset was retrieved from Oracle DB 8.1.7. The dates were stored as "YYYY" format. Due to the native driver obtained from CF5, the year appeared to retrieve "YY" format. If date is greater or equal to 2030, it displayed the date as 19xx instead of the 20xx. If my date field is below 2030, then the format is correct.
<cfoutput query="myquery"> #DateFormat(startdatefield, "DD-MM-YYYY")# - #DateFormat(enddatefield, "DD-MM-YYYY")# </cfoutput> Any idea? TIA Anthony ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481
