>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?
Is it a date type field or a character field containing a date? Date fields index correctly. And even if you're using a date field, you may want to use DTOS(datefield) for the index, in case you need to concatenate something else to it.