Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with VFP 6 and dates
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00198872
Message ID:
00200866
Views:
11
>>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,
José Augusto Cavalcanti
Global Connection
jose.cavalcanti@globalconnection.com.br
Previous
Reply
Map
View

Click here to load this message in the networking platform