I tried query of query, but it treats it as a string, not a date. I just found an article that mentions a query sort custom tag I am going to try it now. I will post if I get good results.
Tim -----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: Friday, October 25, 2002 8:42 AM To: CF-Talk Subject: Re: Verity Ordering Take 2. Quoting Timothy Heald <[EMAIL PROTECTED]>: > > I have 2 Verity indexes I am searching. They both contain a filed > date_created, and I have added this field as custom2 to the search. > I need to be able to sort by date off of that field. Now it is > returning the field as a string right now unfortunately. IS there > any easy (or even not so easy) way of doing this? I haven't been > able to come up with anything yet, I mean I could write a sort that > would have to basically do 3 bubble sorts on all of the 300,000 or so > records I am dealing with. The date is being returned in the format > dd-mmm-yy or 25-OCT-02. If you make sure that the date is returned as YYYYMMDD sorting is pretty easy. Also, doesn't Verity return a query? Can't you use QofQ? 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