Mandatory Date Range Filter

Description

This filter control is commonly used to filter datasets based on a specific field identified in the Filter property. This is a single-field filter that allows date range selection, which includes both start and end dates. One date picker is provided for each. When the control is enabled, both From and To fields applied. This is suitable for date and datetime field types (field identified for Filter).

Viewer Usage

There are two input fields available. The From date picker allows selection of the lower boundary or start date while the To date picker allows selection of the upper boundary or end date. The values are inclusive.

To open the date picker, click on the date picker button corresponding the field.

Number Description
1 Navigates to the previous year and updates the displayed calendar accordingly.
2 Navigates to the next year and updates the displayed calendar accordingly.
3 Navigates to the previous month and updates the displayed calendar accordingly.
4 Navigates to the next month and updates the displayed calendar accordingly.
5 Clicking on any day on the displayed calendar sets the field value to the selected date and closed the date picker. The selected value is reflected on the displayed date label.

If no Initial Value is set for the control, the From date is set on the first day of the current year in local time by default while the To date is set on the current date in local time.

The range of each date picker is dependent on the other. The From date cannot be later than the To date and the To date cannot be earlier than the From date. The most recent date that can be selected on the From date picker is the current value set for the To date. Likewise, the earliest date that can be selected on the To date picker is the current value set for the From date.

Specific Properties

Below are the fields that are specific to this control:

Field Description Mandatory Input Type Constraints Default Value
Initial Values Determines the initial set or selected values upon loading in the Dashboard Viewer. Y Select 1 value can be selected. Available options are:

- None
From: First day of the current year in local time
To: Current day in local time

- Today
From: Current day in local time
To: Current day in local time

- Last Week
From: Today in local time minus 6 days
To: Current day in local time

- Last Month
From: Current day in local time minus 1 month plus 1 day
To: Current day in local time

- Last Quarter
From: Current day in local time minus 3 months plus 1 day
To: Current day in local time

- Last 6 Months
From: Current day in local time minus 6 months plus 1 day
To: Current day in local time

- Last Year
From: Current day in local time minus 1 year plus 1 day
To: Current day in local time
“None”