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