Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Determining AGE OF DEATH

Topic Labels: Scripting extentions
635 5
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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?