Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wich Birthdays for two given dates
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00363237
Message ID:
00363243
Vues:
21
*dob = birthdate, dstart = initial date, dend = final date

SELECT * FROM clients ;
   WHERE MONTH(clients.dob) >= MONTH(dstart) AND ;
         MONTH(clients.dob) <= MONTH(dend) AND ;
         DAY(clients.dob) >= DAY(dstart) AND ;
         DAY(clients.dob) <= DAY(dend)
>I need to make a reports, where I can see al clients with their birthday, having the date of birth, an initial date and a final date.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform