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.5) C.2 Built-in Date Groupings >>