Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Findout year except given year
Message
 
À
15/04/2005 00:00:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Divers
Thread ID:
01004465
Message ID:
01004994
Vues:
15
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform