TimePeriodType enumeration

TimePeriodType enumeration

Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.

The TimePeriodType type exposes the following members:

Fields

FieldDescription
TODAYToday’s date.
YESTERDAYYesterday’s date.
TOMORROWTomorrow’s date.
LAST_7_DAYSA date in the last seven days.
THIS_MONTHA date occurring in this calendar month.
LAST_MONTHA date occurring in the last calendar month.
NEXT_MONTHA date occurring in the next calendar month.
THIS_WEEKA date occurring this week.
LAST_WEEKA date occurring last week.
NEXT_WEEKA date occurring next week.
THIS_YEARA date occurring this year.
Only for .ods.
LAST_YEARA date occurring last year.
Only for .ods.
NEXT_YEARA date occurring next year.
Only for .ods.

See Also