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
Blackbaud CRM / Prospect Plan
  • Jun 10, 2019

    Admin response

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

  • Attach files
  • 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.

    Attachments Open full size
  • Admin
    Pat Conley commented
    June 10, 2019 18:33

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

    Attachments Open full size
  • 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 

    Attachments Open full size
  • +9

Related ideas