Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Calculate details for a coffin nameplate (# Years, # Months, # Days)

Topic Labels: Formulas
Solved
Jump to Solution
1565 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ross_Drummond1
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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"

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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"

That works amazingly. Thank you so much! If ever you need a nameplate, just shout :winking_face: