Jon, disregard this one, I answered too quickly :) See another one.

It should be str or padl, since you're receiving difference, which would be a number.

>>For some reason, I'm stumbling trying to figure this one out, so I'm looking for suggestions.
>>
>>We have a file of interest rates which we are currently indexing on:
>>

BankCode+DTOS(ValueDate)

>
>

BankCode+dtos(date()-ValueDate)

>
>>
>>Our form class makes use of this primary tag to properly populate our 2 combo boxes for the 2 key fields for the user to choose the right record from. We have a user that wants us to change the intial display to be based on the most recent date instead of the first date for the corresponding bank code.
>>
>>So, the question is: how do I create an index expression that produces an ascending sort of the bank code and a descending sort of the date? We can't change the form to use a view or SQL cursor because that would be too huge an overhaul for this one item. :)
>>
>>TIA
>>
>>Laterness,
>>Jon