Date lookup

When you specify a value, or range of values, for an item that is a date, the Date Filters dialog is displayed.

You can use the Date Filters dialog to specify fixed date, for example, 01/01/yyyy. Or, you can specify a relative date, by using the current date plus a specified increment or decrement.

To select a date, right-click a date item in the Filter section and select Lookup. Then, specify the From Date and the To Date, and then click OK.

When the Date Filters dialog opens for a date item with no value, the default value is the current date.

To specify a fixed date, click the calendar or fill in your date.

To specify a relative date, specify the number of Days, Weeks, Months, or Years you want to increment or decrement by.