Help

Calculating age between two dates

1244 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rod_Myers1
4 - Data Explorer
4 - Data Explorer

I am trying to calculate the age for an actor based on their date of birth and their date of death. For actors who are still living, I want to use today’s date as a variable for their current age. For actors who are no longer living, their date of death is the determinant for their final age. What do I do?

2 Replies 2

This formula will use today’s date if the {Date of Death} field is left blank.

IF(
   {Date of Birth},
   DATETIME_DIFF(
      IF(
         {Date of Death},
         {Date of Death},
         TODAY()
      ),
      {Date of Birth},
      'years'
   )
)

This formula worked very well for most records except for one thing: when the field {DIED} is filled, I need a formula to take care of one field {AGE @ DEATH}. How would I do this?

Rod Myers