Enum DateTimeGroupingRuleType

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.

Properties

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.