1. Click Queries
  2. Select a category that you want to store this query in
  3. Select New Query under the tasks menu
  4. Name the query
  5. Set the Starting criteria to Base/All Constituents
  6. Set the Data Return Type to Journal Entries
  7. Under MATCH select All of my Criteria
  8. Select Commonly Used Fields from the Available Fields drop down menu and click Journal Entry Type
  9. Select Pledge and Upgraded Pledge Select Dates from the Available Fields drop down menu and click Pledge Payoff Date
  10. Fill in the Start Date and End Date
  11. Click Save and Preview