thanks for your replies. I am using mysql as well and the dates are fine in mysql. I run the command in mysql and it outputs the results. I am also using the cfqueryparam
The problem occurs somehow in the date format, as when i convert it back to supposedly yyyy/mm/dd i cfoutput'd the result to see why there was a problem and noticed that tbe date format was wrong on some of them. hmmm, i think maybe a quick way of getting around it is to store dates in session variables, format the dates for display and use the session variables which are the same as they come out of the database to requery the database. I would prefer to find why this occuring though thanks for your help 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:258201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
