Enum DateTimeGroupingRuleType

AI-generated Key Takeaways

DateTimeGroupingRuleType defines types of date-time grouping rules.
Examples assume the spreadsheet locale is "en-US", and grouping buckets may be translated based on the locale.
To call an enum, use its parent class, name, and property, like SpreadsheetApp.DateTimeGroupingRuleType.SECOND.
The properties list provides various ways to group date-time data, such as by second, minute, hour, day, month, year, or combinations thereof.

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`.