Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems w. SQL ORDER BY on Date type fld
Message
From
28/08/2003 11:52:40
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
28/08/2003 11:44:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00824236
Message ID:
00824241
Views:
20
Hi Donald!

Try this:
SELECT rcvdte from lar_sum ;
WHERE rcvdte < DTOT({^1996-01-01}) ;
AND !EMPTY(rcvdte) ORDER BY TToC(rcvdte, 1) ASC
Bye!
Erick
Força Sempre!
Strength Always!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform