Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Birthdays this week
Message
From
01/04/2009 08:52:25
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01389309
Message ID:
01392545
Views:
119
>>Thanks, I think that is fairly close to what I need.
>>
>>The date() function in your example would fail fail if a person happened to be born on Feb. 29 - I believe that I'll have to convert those dates to Feb. 28, using an iif().
>
>Hilmar,
>
>See Birthday Query in VFP for a query that addresses your concern.

OK, thanks. I find the solution with gomonth() quite interesting.

Anyway, I already finished coding this - the solution I used is to extract the last four digits of all dates (dtos()) and doing comparisons based on this.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform