Also see DTOS().
>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