Hi Cetin!
Yep, that's what I'm wanting to do. Thanks!
>>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
Jim Philippi
quando omni flunkus moritati