C.2 Built-in Date Groupings
The following built-in date groupings are available for columns with a Date format.
Table 2. Built-in date grouping
DAte group |
value in the group column |
Year |
Date grouped at the year level |
Quarter |
Date grouped at the quarter level |
Month |
Date grouped at the month level |
Week |
Date grouped at the week level |
Day |
Date grouped at the day level |
Hour |
Date grouped at the hour level |
Minute |
Date grouped at the minute level |
Second |
Date grouped at the second level |
Quarter of Year |
Ordinal number: 1st, 2nd, 3rd, 4th |
Month of Year |
Month name: Jan, Feb, etc. |
Week of Year |
Numbers 1-52 |
Day of Month |
Numbers 1-31 |
Day of Week |
Day of week name: Sun, Mon, etc. |
Hour of Day |
Numbers 0-23 |
See the Grouping section for information about using these predefined groupings. See Creating a Named Grouping for information about creating alternative groupings.
| << C.1 Built-in Date Ranges | © 1996-2013 InetSoft Technology Corporation (v11.4) | Report Design >> |