Showing related tags and posts across the entire site.
-
When I did a recent annual appeal I was able to sort those donors who gave at least $1 at any time. Now I'm trying to create a sort of those on my list who have never given one-time or monthly. How do I lookup or sort to find that?
-
And so for SYBUNT (Some Year But Not This Year) gifts the formula would be just a little bit different, correct? (((Contact.ContactID IN (SELECT Gift.ContactID FROM Gift ))) AND (NOT ((Contact.ContactID IN (SELECT Gift.ContactID FROM Gift WHERE GiftDate >= Now()-365))))) You have a good idea, Colby...