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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm