Enum DateTimeGroupingRuleType

The types of date-time grouping rule.

The examples below assume the spreadsheet locale is "en-US", grouping bucket may be translated based on the spreadsheet locale.

To call an enum, you call its parent class, name, and property. For example, SpreadsheetApp.DateTimeGroupingRuleType.SECOND.

Property	Type	Description
`UNSUPPORTED`	`Enum`	A date-time grouping rule type that is not supported.
`SECOND`	`Enum`	Group date-time by second, from 0 to 59.
`MINUTE`	`Enum`	Group date-time by minute, from 0 to 59.
`HOUR`	`Enum`	Group date-time by hour using a 24-hour system, from 0 to 23.
`HOUR_MINUTE`	`Enum`	Group date-time by hour and minute using a 24-hour system, for example `19:45`.
`HOUR_MINUTE_AMPM`	`Enum`	Group date-time by hour and minute using a 12-hour system, for example `7:45 PM`.
`DAY_OF_WEEK`	`Enum`	Group date-time by day of week, for example `Sunday`.
`DAY_OF_YEAR`	`Enum`	Group date-time by day of year, from 1 to 366.
`DAY_OF_MONTH`	`Enum`	Group date-time by day of month, from 1 to 31.
`DAY_MONTH`	`Enum`	Group date-time by day and month, for example `22-Nov`.
`MONTH`	`Enum`	Group date-time by month, for example `Nov`.
`QUARTER`	`Enum`	Group date-time by quarter, for example Q1 (which represents Jan-Mar).
`YEAR`	`Enum`	Group date-time by year, for example 2008.
`YEAR_MONTH`	`Enum`	Group date-time by year and month, for example `2008-Nov`.
`YEAR_QUARTER`	`Enum`	Group date-time by year and quarter, for example `2008 Q4` .
`YEAR_MONTH_DAY`	`Enum`	Group date-time by year, month, and day, for example `2008-11-22`.

Enum DateTimeGroupingRuleType Stay organized with collections Save and categorize content based on your preferences.