The Date Range window is displayed when editing the Test Value field in the Filter Editor, and a Test Condition of In the Next, In the Last, Older Than, or Beyond is selected.

The Date Range window is used to specify the time frame of the Field Name selected. The time frame consists of three parts: the Test Condition, a number, and a unit of time.

Test Condition (In the Next, In the Last, Older Than, Beyond) The first part of the time frame. This value is specified on the Filter Editor window and cannot be edited in the Date Range window.
Number (1-99,999) The second part of the time frame is a number that modifies the unit of time. This field has a default of 0.
Unit of Time The third part of the time frame is a unit of time that can consist of Days, Weekdays, Weeks, Months, or Years.

After specifying the time frame, the actual date range that will be used is shown below the settings. This date range is determined based on the System Date and the time frame specified, and will be displayed in the following format:

In the Next mm/dd/yyyy - mm/dd/yyyy
In the Last mm/dd/yyyy - mm/dd/yyyy
Older Than Past - mm/dd/yyyy
Beyond mm/dd/yyyy - Future

Notes

When specifying a Test Condition of In the Next or In the Last, the date range will include today's date.

When specifying a Number of 0, the date range will include only today's date, with one exception. If today is Sunday and you select In the Last 0 Weekdays, the date range will include the previous Friday, today (Sunday), and tomorrow (Monday).

If today is Thursday and you select In the Next 2 Weekdays, the date range will include today (Thursday) through Monday, including Saturday and Sunday.