>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