If the periods of time are longer than or shorter than one year, create two queries and merge:
- Create a new Constituent query (Query 1) filtering on Gifts > Gift Date between [the first date range].
- Create a new Constituent query (Query 2) filtering on Gifts > Gift Date between [the second date range].
- Merge the two queries using SUB as the operator. Query 1 is the Primary and Query 2 is the Secondary.
Gift Date between [first date range]
AND Gift Date not between [second date range]
Summary Information > Summary for Gift > Total Amount of Gifts equals $0 filtering on [date range of no giving]