Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select problem
Message
From
18/04/2007 15:23:52
Olaf Doschke
Setmics
Hamburg, Germany
 
 
To
16/04/2007 12:02:01
Agnes Lee
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Select problem
Miscellaneous
Thread ID:
01216288
Message ID:
01217447
Views:
10
? "SHA/AI/010/04/2006" > "SHA/AI/004/03/2007"
? "SHA/AI/010/04/2006" < "SHA/AI/013/03/2007"
You may read it as some prefix with a date, but you are making string comparisons. There is a reason why DTOS() has the format "YYYYMMDD" and not "DDMMYYYY".

Store all your values as ".../YYYY/MM/DD" and you will be fine.

Bye, Olaf.
Previous
Reply
Map
View

Click here to load this message in the networking platform