You are the man, I didn't even think about that. Ok, so is there a function (like convert() in SQL Server) that would let you change the date format for the whole column at once?
Tim -----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: Friday, October 25, 2002 9:06 AM To: CF-Talk Subject: RE: Verity Ordering Take 2. Quoting Timothy Heald <[EMAIL PROTECTED]>: > > I tried query of query, but it treats it as a string, not a date. If formatted as yyyymmdd that is not a problem. That is exactly why it is the standard dateformat, you can sort it :) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm