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

    Interface DateParts

    A serial date split into fields — see IFormulaContext.getDateParts.

    These are the spreadsheet calendar's fields, not the Gregorian one's: day may be 0 (1900-01-00) and February 1900 has 29 days.

    interface DateParts {
        day: number;
        dow: number;
        hour: number;
        millis: number;
        minute: number;
        month: number;
        second: number;
        year: number;
    }
    Index
    day dow hour millis minute month second year
    day: number

    Day of month, 1-based. 0 for 1900-01-00.

    dow: number

    Day of week, 1 = Monday ... 7 = Sunday.

    Derived from the serial throughout, so below serial 61 it follows the legacy calendar rather than the real one. This is the same value ddd/dddd render.

    hour: number

    Hour on a 24-hour clock.

    millis: number

    Milliseconds.

    minute: number

    Minute of the hour.

    month: number

    1 = January ... 12 = December.

    second: number

    Second of the minute.

    year: number

    Full year.

    Settings
    Member Visibility

    On This Page
    Properties