>>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.