This query example would return all donors who only donated in 2017 and never at any other time.
- Create a Constituent Type query.
- Set your output fields such as...
- Constituent Number
- First Name
- Last or Org Name
- First Gift Date Ever
- Last Gift Date Ever
- Filter on First Gift Date Ever greater than or equal to 2017-01-01
Filter on Last Gift Date Ever Less Than or Equal To 2017-12-31