The calculation is based on an if/else scenario:
If date1, calculate years from date1 until todays date... Else, calculate years between date1 and date2
The dates for calculation will be pulled from two fields in a collection, the date of birth and the date of their passing.
I have attached a screenshot of the how it will display. The actual dates will be hidden from view. Here’s my share link:
And heres a link to the live WIP site:
Thanks so much and cheers!