NOTE: I updated the bad link below.

We have a new SQL recipe for a report that returns all donors whose first gift to the church was in the past 365 days. You can add it to the Toolbar and run it from Reports in the main menu. You can also download it to Excel.

The report will list each individual donor, his PID# (which links to his people record), the date of his first contribution, and the total number of contributions during the 365 day period. It is sorted by date with the most recent at the top. Those with both a date and time are from online giving.

Here is a sample report:

Like all of our SQL scripts, this is a recipe you can copy and paste into your database.

Read more...