To format values according the A Date Occurring condition, click the menu button of the required dimension and select Add Format Rule | A Date Occurring. The A Date Occurring dialog box is displayed, which allows you to select a date-time interval(s) whose value should be formatted.
The following intervals are supported:
|
Interval |
Description |
|---|---|
|
Is beyond this year |
Dates that follow the current year. |
|
Is later this year |
Dates of the current year starting from the following month. |
|
Is later this month |
Dates of the current month that follow the next week. |
|
Is later this week |
Dates of the current week starting from the day after tomorrow. |
|
Is next week |
Dates that belong to the following week. |
|
Is tomorrow |
Dates following the current date. |
|
Is today |
Dates equaling the current date. |
|
Is yesterday |
Dates that are one day prior to the current date. |
|
Is earlier this week |
Dates of the current week that are prior to yesterday. |
|
Is last week |
Dates of the previous week. |
|
Is earlier this month |
Dates of the current month that are prior to the previous week. |
|
Is earlier this year |
Dates of the current year that are prior to the current month. |
|
Is prior to this year |
Dates that are prior to the current year. |
|
Empty |
Does not specify any condition. |
|
Beyond |
Dates occurring three months from the current month and later. |
|
ThisWeek |
Dates that belong to the current week. |
|
ThisMonth |
Dates that belong to the current month. |
|
MonthAfter1 |
Dates that belong to the following month. |
|
MonthAfter2 |
Dates that belong to the month two months after the current month. |
|
MonthAgo1 |
Dates that belong to the previous month. |
|
MonthAgo2 |
Dates that belong to the month two months ago. |
|
MonthAgo3 |
Dates that belong to the month three months ago. |
|
MonthAgo4 |
Dates that belong to the month four months ago. |
|
MonthAgo5 |
Dates that belong to the month five months ago. |
|
MonthAgo6 |
Dates that belong to the month six months ago. |
|
Earlier |
Dates that belong to the month seven months ago and earlier. |