TimePeriodType Enum
Contents
[
Hide
]TimePeriodType Enum
Used in a FormatConditionType.TimePeriod conditional formatting rule.These are dynamic time periods, which change based onthe date the conditional formatting is refreshed / applied.
type TimePeriodType int32
Fields
| Field | Description |
|---|---|
| Today | Today’s date. |
| Yesterday | Yesterday’s date. |
| Tomorrow | Tomorrow’s date. |
| Last7Days | A date in the last seven days. |
| ThisMonth | A date occurring in this calendar month. |
| LastMonth | A date occurring in the last calendar month. |
| NextMonth | A date occurring in the next calendar month. |
| ThisWeek | A date occurring this week. |
| LastWeek | A date occurring last week. |
| NextWeek | A date occurring next week. |
| ThisYear | A date occurring this year.Only for .ods. |
| LastYear | A date occurring last year.Only for .ods. |
| NextYear | A date occurring next year.Only for .ods. |