Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date to String Descending Indexing
Message
From
05/09/2014 17:45:41
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01607099
Message ID:
01607102
Views:
58
>Have a String Index Expression with a DTOS({Date Field}) Component which needs to be Sorted in Descending Order
>
>How can I accomplish this?
str(Date(2100,1,1)-yourdate,5)
However, I strongly advice against having this index key, if this is for a report. Instead you "Select * from yourtable order by yourdate descending into cursor yourcursor".
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform