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