Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Findout year except given year
Message
 
To
15/04/2005 00:00:54
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01004465
Message ID:
01004994
Views:
23
If I remember corectly You didn't want the years 2004 and 2005 right? If so then:
SELECT * FROM YourTable WHERE .NOT. INLIST(YEAR(YourTable.YourDateField), 2004, 2005) INTO CURSOR cCursor
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform