May I ask WHY you need such an index tag? If you have index tags on the relevant fields, a SQL Select statement is normally instant, and most likely gives you exactly what you really want.
>Hi,
>
>I'm trying to create an index with the balance in descending order (first by time, then by balance). I can not figure this out.
>
>I tried this expression, but it's not working and I don't see why
>
>index on IIF(cStatus='PAYMENT ARRANGEMENT BROKEN','0','1') + DTOS(TTOD(tScheduleTime)) + ;
>*PADL(99999999999999 - yBalance,14,'0') tag tSchedule FOR !DELETED()
>
>Thanks.