You may want to try comparing something like 9/10/04 and 11/10/04 and see if it works correctly. Datewise, of course Nov is after Sept, but alphabetically "9" would sort higher than "1". It may be by accident the two strings you submitted worked out OK, but not all of them will.
>Not sure but it works just like that, no converting needed. >I was thinking that it would have to be date objects myself but hit >that submit on accident and it worked so I havent fooled with it. The >dates will be in a mm/dd/yyyy or m/d/yy or m/d/yy or mm/dd/yy format, >not sure if that helps or not. > > > >On Mon, 20 Dec 2004 14:02:17 -0400, Larry White <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54