Path: utzoo!mnetor!uunet!lll-winken!lll-lcc!ames!hao!gatech!uflorida!beach.cis.ufl.edu!esr
From: esr@beach.cis.ufl.edu (Edward Roepe)
Newsgroups: comp.databases
Subject: dbase date indexing
Message-ID: <11705@uflorida.cis.ufl.EDU>
Date: 25 Feb 88 04:43:48 GMT
Sender: news@uflorida.cis.ufl.EDU
Reply-To: esr@beach.cis.ufl.edu (Edward Roepe)
Organization: UF CIS Department
Lines: 13

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