
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2021 07:20 PM
Hi, I need to calculate the age of a Deceased. I assume a formula is needed. I have Date of Birth and Date of Death to work with and I need the know the age in Years, Months and Days.
Any help would be greatly appreciated.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2021 09:03 PM
Fairly straightforward until you get to the days component. Not sure if there’s a more efficient formula than:
DATETIME_DIFF({Date of Death}, {Date of Birth}, "years")
& " years, "
& MOD(DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), 12)
& " months, "
& DATETIME_DIFF(
{Date of Death},
DATEADD({Date of Birth}, DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), "months"),
"days"
)
& " days"

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2021 09:03 PM
Fairly straightforward until you get to the days component. Not sure if there’s a more efficient formula than:
DATETIME_DIFF({Date of Death}, {Date of Birth}, "years")
& " years, "
& MOD(DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), 12)
& " months, "
& DATETIME_DIFF(
{Date of Death},
DATEADD({Date of Birth}, DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), "months"),
"days"
)
& " days"

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2021 09:24 PM
That works amazingly. Thank you so much! If ever you need a nameplate, just shout :winking_face:
