When creating a query on a certain date range you will want to add Journal Entry Date into the query criteria. On the Edit Query step, under Criteria:
  • Click on the drop down box and select Commonly Used Fields
  • Select Journal Entry Date
  • Enter the date range
Example- you want to find journal entries created between the start of 2018 until the end of March 2018 you would enter:
  • Start Date: 01/01/2018
  • End Date: 31/03/2018
Entering this field will refine the criteria, showing only those journal entries created in that date range. It is possible to add date ranges for things like:
  • Account Created Date
  • Account Last Modified Date
  • Scheduled Payment Date