SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface TimePeriodOption

    interface TimePeriodOption {
        anchorDate?: number;
        maxVal?: number;
        type?: ICondition.TimePeriodType;
    }
    Index
    anchorDate? maxVal? type?
    anchorDate?: number

    Optional anchor date (serial) used as "today" for relative periods.

    If omitted, the operator uses ICondition.IContext.getNow().

    maxVal?: number

    Optional precomputed max value for the period.

    This is required for: today, yesterday, tomorrow, nextWeek, thisWeek, lastWeek, nextMonth, thisMonth, lastMonth, nextQuarter, thisQuarter, lastQuarter, nextYear, thisYear, lastYear, and yearToDate.

    This is an optimization only.

    type?: ICondition.TimePeriodType

    The time-period to compare against (e.g. "today", "lastWeek").

    Settings
    Member Visibility

    On This Page
    Properties