[comp.databases] dbase date indexing

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