i just took of the format to dd/mm/yyyy when i retrieved the date from the database and left the format to yyyy/mm/dd when i sent it to a query for querying the database and it now works fine.
So i suppose if i am going to display it to the user i can use the cfinput datefield type with a mask of dd/mm/yyyy but this is very strange why this might happen. this does seem like an error in the dateformat function and i would be grateful if anyone knows why this may happen or if there is something i can do to stop it from happening thanks again ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
