Try following

Bankcode+STR(date(9999,12,31)-ValueDate,8)

>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)

>
>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