You can try this
<cfset temp = SetLocale("en_GB")>
<cfoutput>
#LSDateFormat(MyDate,"dd.mm.yyyy")#
</cfoutput>
I use same structure for German and Turkish pages.
Sincerely,
OÄuz Demirkapı
Richard White wrote:
> thanks for the replies i will look into your suggesstions.
>
> Thanks david my database is mysql and it stores and outputs in the format of
> yyyy/mm/dd but my app will be basedo n the UK so i need it in the format of
> dd/mm/yyyy.
>
> I have been getting it out of the database and storing it in a sessiopn
> variable for whenever i need it, i only format it using the dateformat
> function in order to display it on screen. And am also having to formatr it
> when i run a new query on the database with the date as it comes out of the
> database as a timestamp so i have to convert it to back to the yyyy/mm/dd
> format
>
> thanks
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258581
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
