I'm trying to limit a report output to show only records within a specified date range using the Order Expected Date field. There doesn't seem to be a filter option where I can select "between". Can anyone advise the correct way for me to do this? My dates are between 01/11/2026 and 31/01/2028 inclusive of each
#Reports & Dashboards
Hello @Donna McKell
You can create two separate filters on the Order Expected Date field and combine them using Filter Logic.
- Open your report in the Edit mode and go to the Filters pane.
- Add the first filter for your start date:
Field: Order Expected Date
Operator: greater or equal (which handles the "inclusive of each" requirement)
Value: 01/11/2026
- Add the second filter for your end date:
Field: Order Expected Date
Operator: less or equal (inclusive of the end date)
Value: 31/01/2028
- Click Add Filter Logic (underneath the filters list).
- Enter the logic combining both filter numbers with an AND operator:
Example: 1 AND 2
- Click Apply, then Save and Run your report.
