Date fields that are available for querying upon will have a small square ‘tick box’ displayed beside them. Clicking this box will open a window which will allow the entry of a Start and End Date range, e.g.
To accept the entered date range click the OK button.
To avoid using the entered date range, or to clear a previously entered date range click the Cancel button.
Once the date selection window has closed the selected date information will be displayed in the field immediately to the right of the tick box, e.g.
There are 5 types of query that can be made on date fields using this pop-up window:
Type of Search
Start Date Value
End Date Value
Search Result
Exact Date Match
01/06/2020
01/06/2020
All records with a date value of the 1st June 2020
Date Range 1 - Specific Date Range
BLANK
01/06/2020
All records with a date in June 2020.
Date Range 2 - Up to a specified date
BLANK
01/06/2020
All records with a date up to and including the 1st June 2020
