-
Math problem
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])
-
Try:
=DateDiff("yyyy", [Date of Birth], [Date of Death])+ Int( Format([Date of Death],"mmdd") < Format( [Date of Birth], "mmdd") )
-
expert's idea! very great!
-
Glad we could help. Try the link in my sig.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules