Thanks for the reply. The work around I have done for this is to use SET DATEFORMAT in mssql and then set the data time to text in the form updates.
Messy though as it means I have to rememeber to set the date formats to text everytime I use Insert/Update for forms from Dreamweaver. This problem only started occuring with DW CS3, btw. Anyone know a better way, please ? -----Original Message----- From: C S [mailto:[EMAIL PROTECTED] Sent: 10 March 2008 13:31 To: CF-Talk Subject: Re: CF_SQL_TIMESTAMP >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:300961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
