Variable TimePeriodTypeConst

Type Declaration

• ReadonlyLast7Days: "last7Days"

  The seven days ending today.

  Remarks

  Conditional formatting only — OOXML's ST_TimePeriod has it, ST_DateTimeGrouping (the AutoFilter domain) does not.

• ReadonlyLastMonth: "lastMonth"

• ReadonlyLastQuarter: "lastQuarter"

• ReadonlyLastWeek: "lastWeek"

• ReadonlyLastYear: "lastYear"

• ReadonlyM1: "M1"

• ReadonlyM10: "M10"

• ReadonlyM11: "M11"

• ReadonlyM12: "M12"

• ReadonlyM2: "M2"

• ReadonlyM3: "M3"

• ReadonlyM4: "M4"

• ReadonlyM5: "M5"

• ReadonlyM6: "M6"

• ReadonlyM7: "M7"

• ReadonlyM8: "M8"

• ReadonlyM9: "M9"

• ReadonlyNextMonth: "nextMonth"

• ReadonlyNextQuarter: "nextQuarter"

• ReadonlyNextWeek: "nextWeek"

• ReadonlyNextYear: "nextYear"

• ReadonlyNull: "null"

• ReadonlyQ1: "Q1"

• ReadonlyQ2: "Q2"

• ReadonlyQ3: "Q3"

• ReadonlyQ4: "Q4"

• ReadonlyThisMonth: "thisMonth"

• ReadonlyThisQuarter: "thisQuarter"

• ReadonlyThisWeek: "thisWeek"

• ReadonlyThisYear: "thisYear"

• ReadonlyToday: "today"

• ReadonlyTomorrow: "tomorrow"

• ReadonlyYearToDate: "yearToDate"

• ReadonlyYesterday: "yesterday"