Hi, 

i have been playing around with date formats for ages and still encountering 
problems. i am in the uk and have set the following code when someone logs in:

<cfset SetLocale("English (UK)")>

i have dates stored in a mysql db which is in the format yyyy/mm/dd

when i try to get data out of the db and put it in the dd/mm/yyyy format i use 
lsdateformat(date,"dd/mm/yyyy")

and it spits out an error: 01/20/2008 is not a valid date format!!

i dont understand this at all, does anyone have any ideas why it would do this. 
i dont understand why it would output this when i am telling it to put it in 
dd/mm/yyyy format not mm/dd/yyyy format

thanks very much 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:296918
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to