eTapestry already has a standard query that does this for you. It is called LYBUNT. LYBUNT stands for Last Year But Unfortunately Not This. So in other words, donors that gave last year, but didn't give this year. There is also a Last Fiscal Year But Unfortunately Not This (LFYBUNT) query if your organization runs on a Fiscal Year.
- Click Queries on the menu bar
- Click the LYBUNT & SYBUNT category
- Click Preview under the LYBUNT query
You may also be interested in building some of your own LYBUNT queries to have more control on the results being returned:
- How can I find donors that gave in one date range, but didn't give in another date range?
- How to Find Constituents in a Query Who Gave a Specific Cumulative Amount Last Year but Not Yet This Year
For additional information on LYBUNT and SYBUNT, please refer to What is a LYBUNT and a SYBUNT?