We can create a Constituent query to find donors who gave this year, but not last.
  1. Navigate to Query > New Query 
  2. For the Query Type, select Constituent 
  3. Select your desired Query format
  4. Click OK
  5. On the Criteria tab, Select Summary Information > Summary for Gift > Total Number of Gifts
    1. On the Criteria tab, for the Operator, select Greater than or equal to
    2. For the Value, enter 1
    3. Select the Filter tab
    4. Under Gift Information, select Gift Date
    5. For the Operator, select equals
    6. For the Date, select This calendar yr
    7. Click OK
    8. Click OK
  6. On the Criteria tab, select Summary Information > Summary for Gift > Total Number of Gifts
  7. When prompted, "Do you wish to apply applicable criteria to this summary field?," click No
    1. On the Criteria tab, for the Operator, select equals
    2. For the Value, enter 0
    3. Select the Filter tab
    4. Under Gift Information, select Gift Date
    5. For the Operator, select equals
    6. For the Date, select Last calendar yr
    7. Click OK
    8. Click OK
  8. If the second piece of Criteria displays as OR, click AND below, so that Query filters on both sets of Criteria
User-added image
  1. Enter your desired Output fields
  2. If desired, Sort your query
  3. Click Run Now or select the Results tab to see your results