To query on all pledges in arrears as of a certain date:
  1. Click Queries
  2. Click Manage Queries
  3. Select a category that you want to store this query in (Ex: Base)
  4. Click New Query under the Tasks menu
  5. Name the query
  6. For Starting Query select Category: Base and Query: All Constituents
  7. For the Data Return Type select Journal Entries
  8. For Criteria Matching select Match Each Criteria
  9. For Criteria select individual Transaction Pledge Arrears
  10. Enter greater than or equal to 1.00
  11. For As of choose Custom Date and enter the specific date that you want
  12. Save and Preview