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?
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'
)
)
1 person likes this
Jeremy_Oglesby wrote:
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
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.