Pledge Amount With Both Joint by Date Range¶
This Condition, located on the Contributions category tab in Search Builder, allows you to find people based on the total amount pledged during a date range. For couples who give jointly, both spouses are returned, no matter which spouse’s record the pledge is on. Individual pledgers are returned as well.
Enter the following:
Comparison and an amount (no dollar sign)
Start Date and End Date - the End Date is included; if it’s left blank, only the Start Date is searched
Fund ID (optional) - leave blank to include all funds
Equal 0 finds people with no pledges in the date range.
Less, LessEqual, and NotEqual find only people with a pledge greater than $0.
Note
You must have the Finance role to get results from this Condition. Without it, the search returns 0 people and does not show an error.
Sample search in Search Builder¶
Use Case
To find every couple and individual who pledged $1,000 or more during a campaign,
select GreaterEqual, enter 1000, and enter the campaign dates.
Use Greater 0 to find everyone who pledged any amount.
Tip
This Condition relies on spouses having matching Contribution Options. Your System Admin can use the Couples With Different Contribution Options report to find and fix mismatches.
Latest Update |
10/20/2026 |
Corrected the statement that individual pledgers are excluded, explained the End Date and zero values, and documented the Finance role requirement. Replaced the outdated screenshot with a current sample search from Search Builder. Renamed the article to match the Condition name in Search Builder. Updated the sample screenshot to match the Use Case.