C.1 Built-in Date Ranges
The following built-in date ranges are available in filtering conditions for Data tables. See the Filtering section for information about using these predefined ranges. See Creating a Date Range for information on specifying alternative ranges.
Last year |
Last month last year |
Last July |
This year |
This month last year |
Last August |
Last quarter |
This January |
Last September |
This quarter |
This February |
Last October |
Last quarter last year |
This March |
Last November |
This quarter last year |
This April |
Last December |
1st Quarter this year |
This May |
Last week |
2nd Quarter this year |
This June |
This week |
3rd Quarter this year |
This July |
Week before last week |
4th Quarter this year |
This August |
Last 7 days |
1st Quarter last year |
This September |
Last 8-14 days |
2nd Quarter last year |
This October |
Last 4 weeks |
3rd Quarter last year |
This November |
Last 5-8 weeks |
4th Quarter last year |
This December |
Last 30 days |
1st half of this year |
Last January |
Last 31-60 days |
2nd half of this year |
Last February |
Year to date last year |
1st half of last year |
Last March |
Month to date last month |
2nd half of last year |
Last April |
Quarter to date last quarter |
Last month |
Last May |
Month to date last year |
This month |
Last June |
Quarter to date last year |
The explanation of the last five ranges is as follows:
• Year to date last year: The same date range provided by the 'Year to date' option (i.e., beginning of year to present date), but offset to the previous year. For example, if today is Nov. 8, 2011, the range selected by 'Year to date last year' is Jan. 1, 2010–Nov. 8, 2010.
• Month to date last month: The same date range provided by the 'Month to date' option (i.e., beginning of month to present date), but offset to the previous month. For example, if today is Nov. 8, 2011, the range selected by 'Month to date last month' is Oct. 1, 2011–Oct. 8, 2011.
• Quarter to date last quarter: The same date range provided by the 'Quarter to date' option (i.e., beginning of quarter to present date), but offset to the previous quarter. For example, if today is Nov. 8, 2011, the range selected by 'Quarter to date last quarter' is July. 1, 2011–Aug. 8, 2011.
• Month to date last year: The same date range provided by the 'Month to date' option (i.e., beginning of month to present date), but offset to the previous year. For example, if today is Nov. 8, 2011, the range selected by 'Month to date last year' is Nov. 1, 2010–Nov. 8, 2010.
• Quarter to date last year: The same date range provided by the 'Quarter to date' option (i.e., beginning of quarter to present date), but offset to the previous year. For example, if today is Nov. 8, 2011, the range selected by 'Quarter to date last quarter' is Oct. 1, 2010–Nov. 8, 2010.
| << Appendix C: Built-in Ranges and Groupings | © 1996-2013 InetSoft Technology Corporation (v11.4) | C.2 Built-in Date Groupings >> |