Skip to main content
Pentaho Documentation

Add a Filter on Date Fields

Use these steps to add a filter that matches a specific value.

  1. In the toolbar, click Filters. The Filters Panel appears above the report.
  2. Click and drag a date field from the right pane into the Filters area. The Filters dialog box opens.
  3. Next to the field name, choose a date constraint from the list, then click the small arrow on the right to display the date picker. To create a "date range" you must add two filters: one for the start date, and one for the end date.
  4. In the date picker choose your date.
  5. Click OK to save your filter.

The report display updates as soon as the filter is added. The filter appears in the Filter box and an icon displays next to the field name in the Data tab. Also, the number of filters added to the report appears next to the filter icon in the toolbar.

You can edit the filter by clicking Edit. You can delete the filter by clicking the delete button.