>Take a look at the Age Calculator class download #
25738. It returns age in years, months, and days. Does that help?
>
>
>>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
See
Re: What is best way to calculate age Thread #
1155605 Message #
1155645What should this class return for today and 02/29/1988?
If it's not broken, fix it until it is.
My Blog