Enum RelativeDate
Stay organized with collections
Save and categorize content based on your preferences.
RelativeDate
An enumeration representing the relative date options for calculating a value to be used in
date-based BooleanCriteria.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.RelativeDate.TODAY.
Properties
| Property | Type | Description |
TODAY | Enum | Dates compared against the current date. |
TOMORROW | Enum | Dates compared against the date after the current date. |
YESTERDAY | Enum | Dates compared against the date before the current date. |
PAST_WEEK | Enum | Dates that fall within the past week period. |
PAST_MONTH | Enum | Dates that fall within the past month period. |
PAST_YEAR | Enum | Dates that fall within the past year period. |
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.
[null,null,["Last updated 2024-12-02 UTC."],[[["\u003cp\u003e\u003ccode\u003eRelativeDate\u003c/code\u003e is used within \u003ccode\u003eBooleanCriteria\u003c/code\u003e for date-based comparisons in Google Apps Script.\u003c/p\u003e\n"],["\u003cp\u003eIt offers various properties like \u003ccode\u003eTODAY\u003c/code\u003e, \u003ccode\u003ePAST_WEEK\u003c/code\u003e, etc., representing different relative date periods.\u003c/p\u003e\n"],["\u003cp\u003eTo use it, call the parent class, name, and property, for example, \u003ccode\u003eSpreadsheetApp.RelativeDate.TODAY\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Enum RelativeDate\n\nRelativeDate\n\nAn enumeration representing the relative date options for calculating a value to be used in\ndate-based [BooleanCriteria](/apps-script/reference/spreadsheet/boolean-criteria).\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.RelativeDate.TODAY`. \n\n### Properties\n\n| Property | Type | Description |\n|--------------|--------|----------------------------------------------------------|\n| `TODAY` | `Enum` | Dates compared against the current date. |\n| `TOMORROW` | `Enum` | Dates compared against the date after the current date. |\n| `YESTERDAY` | `Enum` | Dates compared against the date before the current date. |\n| `PAST_WEEK` | `Enum` | Dates that fall within the past week period. |\n| `PAST_MONTH` | `Enum` | Dates that fall within the past month period. |\n| `PAST_YEAR` | `Enum` | Dates that fall within the past year period. |"]]
