dateFormat

Description

Optional. Defines the format of dates in the spreadsheet

Usage

dateFormat?: string;

Default config

dateFormat: "%d/%m/%Y"

Example

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {
    dateFormat: "%D/%M/%Y",
    // other config parameters
});

spreadsheet.parse({
    styles: {
        // a set of styles
    },
    data: [
        {cell: "B1", value: "03/10/2022", format: "date"},
        {cell: "B2", value: new Date(), format: "date"},
       ]
});

List of characters

DHTMLX Spreadsheet uses the following characters for setting a date format:

Character	Definition
%d	day as a number with leading zero, 01..31
%j	day as a number, 1..31
%D	short name of the day, Su Mo Tu...
%l	full name of the day, Sunday Monday Tuesday...
%m	month as a number with leading zero, 01..12
%n	month as a number, 1..12
%M	short name of the month, Jan Feb Mar...
%F	full name of the month, January February March...
%y	year as a number, 2 digits
%Y	year as a number, 4 digits
%h	hours 12-format with leading zero, 01..12)
%g	hours 12-format, 1..12)
%H	hours 24-format with leading zero, 00..23
%G	hours 24-format, 0..23
%i	minutes with leading zero, 01..59
%s	seconds with leading zero, 01..59
%a	am or pm
%A	AM or PM
%u	milliseconds

Change log:

• From v4.3, it is possible to set the date as a new Date() object in the data set
• Added in v4.2

Related articles: Date format