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.5) Ad Hoc Reporting >>