>I've got a silly problem with CF_SQL_TIMESTAMP and CF_SQL_DATE changing my >dates from dd/mm/yyyy to mm/dd/yyyy.
Most of the standard date functions use U.S. date formatting rules. So I imagine 12/04/2008 would be converted to December 4th not April 12th. You might try parsing it into a less ambiguous format like yyyy-mm-dd or look at the LS (locale specific) date functions if appropriate. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
