Math problem

[kbrodrick]

I want to calculate a persons age from the fields Date of Birth and Date of Death.
I have been able to get it to calculate the years but if DOD was before their birthday it is one year off. I can't seem to get it right. this is what i have that calculates it so far.
=DateDiff(“YYYY”,[Date of Birth],[Date of Death])

[RuralGuy]

Try:
=DateDiff("yyyy", [Date of Birth], [Date of Death])+ Int( Format([Date of Death],"mmdd") < Format( [Date of Birth], "mmdd") )

[tinytree]

expert's idea! very great!

[RuralGuy]

Glad we could help. Try the link in my sig.