Stay organized with collections Save and categorize content based on your preferences.
DateTimeGroupingRuleTypeThe 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.
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.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["`DateTimeGroupingRuleType` defines how date and time values are grouped in Google Sheets, like by hour, month, or year."],["These grouping rules influence how data is organized and summarized, impacting features such as pivot tables and charts."],["You can access these rule types using `SpreadsheetApp.DateTimeGroupingRuleType` followed by the specific rule, such as `SpreadsheetApp.DateTimeGroupingRuleType.SECOND`."],["Grouping buckets might be translated based on the spreadsheet's locale setting."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4