Does anyone have a good way of pulling donors by their final pledge payment date? I'm looking for a way to know what "monthly" (sometimes it isn't precisely monthly) donors will have completed their pledge soon and are ready to be solicited for renewal. I can't necessarily pull by gift date either, because our pledges last anywhere from 4-12 months from what I've observed so far.
I've jerry-rigged a way to extract the folks I want for now, but if anyone has a fancy bit of SQL I'd be much obliged.
In our acknowledgement report we added the field "Contribution Balance" so we can easily see whose pledges completed.
Megan