Try dtos(op_ord_date) instead of the dtoc clause, and tell me if this helps

Jaime

>I have a view that orders the data by following:
>
>

> ORDER BY O_ord_pay.op_vendor, O_ord_pay.op_ord_date
>

>
>I am now trying to create a index that should replicate the above sorted order as follows:
>
>

>INDEX ON op_vendor+dtoc(op_ord_date) TAG (vendorord) ascending
>SET ORDER TO (vendorord) ascending
>
>

>
>When I run the second senerio, the order of data doesn't come out like the view order. What I'm I doing wrong?
>
>Thanks
>Nick Patel