I'm not sure what you mean. This calculation evaluates to an acsending number converted a string. This effectively inverts the date order. I don't see where dtos() would fit in.
>Hi Ken,
>
>Why not use DTOS() instead?
>
>>Assuming your talking about a concatenated key. Using the following key expression should do the trick.
>>
>>myCharField + str({1/1/9999}-MyDateField)
>>
>>Wow, I really feel sorry for those Y10K programmers ;)
>>
>>>I am creating an index with the primary field being character and the secondary field a date. I want the date to be in descending order but the character in ascending. Can I do this?
>>>
>>>Thanks.
kenweber
GCom2 Solutions
Microsoft Certified Professional