1. Select Query. 
  2. Click New Query.
  3. Select Query Type=Gift.
  4. Select the Query Format: Static or Dynamic.
  5. In Criteria, select Gift Information>Gift Date.
  6.  Select the desired operator:
    • To capture all gifts given within a specific range, select Operator=Between. Enter a Start Date and End Date to define the specific range.
    • To capture all gifts given within a pre-defined range in the Raiser's Edge, select Operator=Equals, and choose one of the pre-set values:
  • Today = Gifts received the day the query is run.
  • Yesterday = Gifts received the day before the query is run.
  • This week = Gifts received within the week the query is run (Sunday to Sunday).
  • Last week = Gifts received the week prior to when the query is run (Sunday to Saturday).
  • This month = Gifts received within the month the query is run.
  • Last month = Gifts received the month prior to when the query is run.
  • This quarter = Gifts received within the quarter of the year that the query is run.
  • Last quarter = Gifts received the quarter of the year prior to the date that the query is run.
  • This calendar year = Gifts received within the calendar year that the query is run.
  • Calendar YTD = Gifts received within the calendar year, up to the date that the query is run.
  • Last calendar year = Gifts received the calendar year prior to when the query is run.