Deceased This Month

This report is for those churches that like to followup with surviving family members on the anniversary of their loved one’s deceased date. The report will find everyone with a deceased day in the current month and will indicate the deceased month/day/year. The report will sort with the most recent date at the top, so it will include anyone deceased in the current month/year.

The report has a link to the person’s record, making is easy for you to contact surviving family members to let them know you are praying for them on this sad anniversary.

Create Deceased This Month Report

Step 1

Go to Administration > Special Content > Setup > SQL Scripts and then click the green + Add New Sql Script File button.

Enter the name DeceasedThisMonth and press Submit.

Step 2

Copy the code below and paste it into the new file. Now press the Save Sql Script button at the bottom of the file.

Step 3

Press the Run Script button at the top of the file, and after the file runs, press the Add Report to Menu link at the bottom of the report so the report will be listed under the main Reports menu.

Code

--Roles=Membership
SELECT PeopleId, Name2, DeceasedDate
FROM dbo.People WHERE DATEPART(MONTH, DeceasedDate) = iif(@p1 = '', datepart(month, getdate()), @p1)
ORDER BY DeceasedDate DESC