FAQ: How Do I Find Donors Who Only Gave in a Certain Year?

This query example would return all donors who only donated in 2017 and never at any other time.

1. Create a Constituent Type query.
2. Set your output fields such as...
   • Constituent Number
   • First Name
   • Last or Org Name
   • First Gift Date Ever
   • Last Gift Date Ever
3. 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
   Make sure the AND operator is between them.