QofQ doesn't seem to do dates well at all. One work around that we have used is if you format dates thusly 'yyyy-mm-dd' (which happens to be iso in xml) you can order / sort in correct order using text functions.
good luck Rob -----Original Message----- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 12:11 PM To: CF-Talk Subject: Query a Query Question Hi All, I'm finally getting around to trying query a query to order info I'm shoving into a WDDX packet. The packet contains three columns, a date, a string and a string. Is it possible to order by the date field? When I order by this column now is sorts the field but treats it like a string, so that 12/12/2002 is less then 12/9/2002. Is this possible? Thanks, Duane ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
