- When running Pledge Reminders, for each month, select the option on the General tab to Create a constituent output query.
- Merge the queries using the And Operator. (You can only merge two queries at a time.)
Note: The resulting merged query includes the people who have received a reminder in each of the previous X months.
- Create a constituent query filtering on Gifts, Gift Date not between [the date range for the X number of months]
- Merge the queries using the SUB Operator.
Note: The Primary query is the query created in the step 2. The Secondary query is the query created in step 4.
The resulting query will be people who have received reminders in those months but never given in that timeframe.
Connect and collaborate with fellow Blackbaud users.