Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Order Event Times from AM to PM?
Message
From
11/04/2001 08:32:40
 
 
To
10/04/2001 05:16:00
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00493754
Message ID:
00494370
Views:
14
Cetin,
Thanks for your reply. I fixed it by putting the AM/PM first in the sorting column, then the corresponding time, so that AM07:45 now comes before PM01:00 (making primary order of column character dependent instead of numerical). Guess it wasn't that hard if I had thought about it more <g>

Thanks,
Mark
>
>Ooops. It would be :
>
>ctot("^2000/1/1 "+left(evt,at('-',evt)-1))
>
>Cetin
Mark Rietman
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform