It is possible to find the number of new sustaining gifts that have been started within a calendar year by running a query:
  1. Select Data Management > Query
  2. Click Create a New Query
  3. Enter a name and description for the query
  4. Click Save
  5. Under the Field Type drop down, select Sustained Giving Information
  6. Under the Field drop down, select Start Date
  7. Click Add Field Clause
  8. Within the drop down menu, Select Falls on or After
  9. Within the Fixed radio button, edit the date so that it reads January 1st of the current year
  10. Click Save
  11. Under the Field Type drop down, select Sustained Giving Information
  12. Under the Field drop down, select Start Date
  13. Click Add Field Clause
  14. Within the drop down menu, select Falls on or Before
  15. Within the Fixed radio button, edit the date so that it reads December 31st of the current year
  16. Click Save
  17. Ensure that the query reads AND (and not OR) between the two query statements
  18. Click Save Query
  19. Click Run Query
If needed, you can then use the query results to create a group, or create a Mail Merge which can be downloaded.