(Chuckle) - You kids! ;)
>Yikes!
>
>mdob = {09/25/1960}
>? YEAR(DATE())-YEAR(mdob)
>
>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.