>>INDEX ON od_tipo_documento + STR(CTOD("31/12/2100") - dt_documento, 5) TAG TIPO
>>
>>And everything is working fine (????).
>>
>>Regards,
>
>Are you trying to put something in descending order? Why not use DESCENDING... or, if you need just the date in descending order, try this...
>
>INDEX ON od_tipo_documento + alltrim(str( {^9999-12-31} - dt_documento ))
>
>Bob
Thanks Bob, but this is exactly what I'm doing. The only difference is that I'm using 2100 instead of 9999...I solved the problem using CTOD("31/12/2100") instead of {^2100-12-31}. Thanks for the manual, but I could not download it from my ISP. I'm waiting for Kevin's message with another copy.
Regards,