That worked like a charm! thx! Duane
-----Original Message----- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 3:20 PM To: CF-Talk Subject: RE: Query a Query Question 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm