>What’s the best way to index by descending date? I need to sort by cRoadName+cMilePost+dDate.
>
>Example:
>
>

(Name)  Airport Road
>(milepost)          1.234        03/30/2001
>                    1.234        03/30/2000
>                    1.234        03/23/1999
>                    2.345        03/30/2001
>                    2.345        03/30/2000
>                    2.345        03/23/1999
>

etc.....
>
>Thanks

Jim,
Actually you sort on Roadname and milepost ascending but date descending, right ?

Then how about :

index on RoadName+transform(MilePost)+padl({^9999/12/31}-dDate,7,'0') tag ..
Cetin