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.