Auto-calculate age at death for deceased constituents

BBCRM already auto-calculates someone's current age if they are living. It would be useful for bequest reporting to have it also auto-calculate a person's age at death (DOD-DOB), so that field could be displayed in queries/reports relating to matured bequests and other planned gifts.
  • Guest
  • Jun 29 2015
  • Reviewed: Voting Open
  • Jun 10, 2019

    Admin response

    In adhoc query, there is a field named 'Deceased years' that displays the age at death.

  • Attach files
      Drop here to upload
    • Guest commented
      17 Jan 18:17

      This idea should possible be merged with https://bbcrm.ideas.aha.io/ideas/CRM-I-593 as they are both asking for the constituent age at the time of death to appear on constituent records / in query.

    • Admin
      Pat Conley commented
      June 10, 2019 18:33

      My mistake, thanks for the catch. Setting back to 'Voting Open'.

    • Kristin Lambert commented
      June 10, 2019 14:28

      I am not sure what happens in anyone else's environment, but for our version of CRM, "Deceased Years" = number of years the constituent has been deceased (current date - deceased date).  

      Example: 

      Date of birth: 4/22/1920

      Date of death: 8/30/2013

      Deceased years: 5 

    • +9