esr@beach.cis.ufl.edu (Edward Roepe) (02/25/88)
This is the commands I use to sort dates in reverse order: Index on ctod('01/01/01')-ctod(date) to work This assumes that: You have a field in the database called date, character 8 This method allows you to do most of the full screen commands such as browse using the index. I normally store dates as characters because they are easier to index on ( substr(date,7,2)+date ) in conjunction with other fields. Ed