How do I get "AGE OF DEATH" Field to stay blank if I don't have a "DATE OF DEATH" entered?
How are you setting the 'Age at Death' field?
If it's a calculation, or an Auto-enter number field, the formula above will be your calculation.
If you are using a script, it will be the calculation for the value you are setting to the field.
Likely, you can just make this an auto-enter calculation or a stored calculation.
IsEmpty ( Date of Death ) ;
Year ( Date of Death ) - Year ( Birthdate ) - ( Date of Death ) < Date ( Month ( Birthdate ) ; Day ( Birthdate ) ; Year ( Date of Death ) ) )
Case ( IsEmpty ( Date of Death ) ; "" ; AgeCalcHere )
Thank you for the info! One other question… Is this a calculation, script or a conditional format?
Thank you!! Worked great!
It's helpful for others searching for similar questions if you mark an answer as correct or helpful. Glad you got it sorted and working.
TSGal or tsplatypus, it would be great if you could move this thread to Discussions, where others can find it. ( steveromig eric_evers RosemaryTietge )
Thanks Josh. I have moved this thread to the Discussions area.
Retrieving data ...