Hi I am upgrading a system originaly written in Fox 2.2 (I think it was 2.2) for DOS. I'm converting it into Vis Fox 6. Some of the index tags in the tables use character prime key fields and do this with DATE fields.

'primekeycharacterfield' + STR(999999-(AS_DATE-{01/01/1900}),6)

I figure that subtracting {01/01/1900} from the date and then subtracting from 999999 will give descending values. The later the date the higher the value.
I'm wondering why the didn't just create a descending index.
It wouldn't make a difference whether the prime key values were in ascending or descending order, it's only the dates that matter.
Could you not create descending indexes in Fox for dos?