Help

Re: Determining AGE OF DEATH

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

I have a formula that calculate’s a person’s age. The problem that I’m having is that when information is entered for ‘Died’, nothing is entered for 'Age of Death’.![Actors|690x225]

What can I do to correct this?

5 Replies 5
Zollie
10 - Mercury
10 - Mercury

Please share the formula. Your image didn’t post - probably because you’re new to the community.

Here is the formula in question:
IF( {BORN}, DATETIME_DIFF( IF( {DIED}, {DIED}, TODAY() ), {BORN}, ‘years’ ))

Hi @Rod_Myers1,

You don’t need the first IF statement. So the formula would just be

DATETIME_DIFF( IF( {DIED}, {DIED}, TODAY() ), {BORN}, 'years')

This will do the following:

If there is a date in Died, the IF formula will return Died and will calculate the difference between Died and Born.

If Died field is empty, the IF will return Today() and will calculate the difference between Born and Today.

BR,
Mo

Rod_Myers1
4 - Data Explorer
4 - Data Explorer

It worked well–thank you very much. I have a problem of using a field for AGE OF DEATH. Is there a formula that would fill that field when DIED is filled?

The above formula is already calculating that. I don’t understand?