Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wich Birthdays for two given dates
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00363237
Message ID:
00363243
Views:
22
*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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform