Message
From
20/09/2006 14:03:30
To
20/09/2006 13:19:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01155605
Message ID:
01155670
Views:
29
(Chuckle) - You kids! ;)
>Yikes!
>
>
>>>>We need totals of clients by age bracket. What is the best way to calculate the age? Right now, we are using:
>>>>
>>>>INT((DATE() - a.dob) / 365)
>>>>
>>>>But that doesn't take into consideration leap years (which could be significant for someone over 90 years old). Any suggestions? Should I just use:
>>>>
>>>>INT((DATE() - a.dob) / 365.25)
>>>>
>>>>Or is there a better (more accurate) way?
>>>>
>>>>Thanks,
>>>>Doug
>>>
>>>if YEAR is enought:
>>>
>>
>>Fabio, that doesn't quite work. It only works if you assume rounding. A person born say, November 1, 1975, is normally considered today (Sept. 20, 2006) to be 30 years old. but your calculation gives back 31.
>Yikes!
>
>mdob = {09/25/1960} && my dob
>? YEAR(DATE())-YEAR(mdob) && returns 46
>>I am NOT 46 yet *G*>
>>>>We need totals of clients by age bracket. What is the best way to calculate the age? Right now, we are using:
>>>>
>>>>INT((DATE() - a.dob) / 365)
>>>>
>>>>But that doesn't take into consideration leap years (which could be significant for someone over 90 years old). Any suggestions? Should I just use:
>>>>
>>>>INT((DATE() - a.dob) / 365.25)
>>>>
>>>>Or is there a better (more accurate) way?
>>>>
>>>>Thanks,
>>>>Doug
>>>
>>>if YEAR is enought:
>>>
>>>YEAR(DATE())-YEAR(a.dob) >>>>>
>>
>>Fabio, that doesn't quite work. It only works if you assume rounding. A person born say, November 1, 1975, is normally considered today (Sept. 20, 2006) to be 30 years old. but your calculation gives back 31.