>Hi there, so here is my problem:
>
>I have a dbf file with 2 date type fields, date1 and date2. How can I index the database on these 2 fields descending, when browse the datab the records to appeir descending .
>
>Ex.
>
>browse normal, I have arranged the records:
>
>date1
>record#1 01.01.2001
>record#2 01.02.2002
>record#3 01.01.2003
>record#4 01.01.2004
>
>date2
>record#5 02.01.2001
>record#6 02.02.2002
>record#7 02.02.2003
>record#8 02.02.2004
>
>After indexing, I need to have when I browse the following:
>
>date2
>record#1 02.02.2004
>date1
>record#2 01.01.2004
>date2
>record#3 02.02.2003
>date1
>record#4 01.01.2003
>date2
>record#5 02.02.2002
>date1
>record#6 01.02.2002
>date2
>record#7 02.01.2001
>date1
>record#8 01.01.2001
>
> |
>How is the ORDER formula to obtain this

INDEX ON MAX(DATE1,DATE2) DESCENDING