Sounds like you have a character field instead of a date field. Date fields are stored internally as YYYYMMDD and index just fine. If you're storing dates as character strings in an MM/DD/YY format then it's likely you've got other problems too. I'd suggest modifying the table(s) and changing to real date fields. BTW you can generate a sortable string of a date field with the DTOS function, this can be useful in a compound index expression.
>MyTable with a date field (8 spaces- i.e 01/10/00) won't index properly. I set order to Date and the 2000 entries appear at the top of the list. How can this be fixed?
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.