Hi, in the past we have had intimidated problems with the dateformat function and mysql
therefore we want to use the setlocale() method to change to english UK. i am a little confused as our mysql wants dates to be in the format of yyyy/mm/dd and of course when we get the date out of the database we need it in the format dd/mm/yyyy therefore does this mean that i should setlocale() to english UK. then when i am getting a date out of the database i use: lsdateformat(date, 'dd/mm/yyyy') then when saving to the database i need to use lsdateformat(date,'yyyy/mm/dd')? if i am write on this can i set the locale in the application.cfm page as we dont have access to the cf administrator on our server? is so could you please give an example and i cant find how to do it? and would it matter that our server is a host in the US - would it override their locale? then like i said do i always have to use the lsdateformat instead of dateformat thanks richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:294923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
