Pledge Completion Date

Tammie Cach Abdu

Hello all,

I am struggling with pledge completions. I need a report for a specific college of when people complete their pledges so they can ask again. I need anyone who has completed a pledge within the previous week. Does anyone do this? I have tried several different ways, and I either get no one, or I get everyone no matter when they completed their pledge. I feel as though I am missing something simple, but I could be wrong.

Aaron Rothberg

Hi Tammie-


How about a constituent query where the criteria are:


Last Payment Made equals Last Week

AND

Gift Pledge Balance equals 0


That seems to work in the test I just ran against our database.