In This Article:

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

    In This Article:

      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

      Example_Query_2017_only.png

      Was this article helpful?
      0 out of 0 found this helpful
      Have more questions? Submit a request

      Comments

      0 comments

      Please sign in to leave a comment.