You can filter information in your view based on a date range relative to the current system date. You can accomplish this
using date-based filters, and entering a text expression describing the relative date or date span you want to display, using the
format <Keyword>+/-<Number>.
- Keyword indicates the time span you want to use. Options include: DAY, WEEK, QUARTER, SEMI, and YEAR.
- + or - indicates whether the time span occurs before or after the chosen date.
- Number indicates the number of the above-mentioned time spans you want to include in the filter.
For example, if you want to look at all Sales for the prior week, your expression would be: WEEK-1.
To create a relative date filter:
1. "Using Filters," create a filter based on a date field. The filter appears in the Filters panel.
2. In the filter's operator, select the date comparison you would like to make.
3. In the filter's text entry box, enter an expression describing the relative date.
For instance, if you want to display all the sales numbers for the month prior to the current date, you would select "is on or after" as the operator and and in the second box you would enter MONTH-1.
(this would show you all results exactly a year prior to the date the report was run)
Another way to enter in the relative date:
- In the date field, click on the calendar icon.
- Click on "Relative Timestamp" and you will access the options on setting up a relative date.
- Click on "Close" once you are done setting the relative date.
