Skip to content

spreadsheet_dateformat_config.md

Latest commit

 

History

History
74 lines (59 loc) · 2.5 KB

spreadsheet_dateformat_config.md

File metadata and controls

74 lines (59 loc) · 2.5 KB
sidebar_label dateFormat
title dateFormat config
description You can learn about the dateFormat config in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet.

dateFormat

Description

@short: 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