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
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.