Timothy, Not very efficient but you could perhaps convert the string to a proper date format at run-time and then sort it.
Dave -----Original Message----- From: Timothy Heald [mailto:healdt@;dsmail.state.gov] Sent: 25 October 2002 13:12 To: CF-Talk Subject: Verity Ordering Take 2. Hey, I know many people are on their way to Orlando, so I don't really expect to get an answer to this :) 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. Any help would be much appreciated. Have fun @ DevCon!! Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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
