Using datePattern and dateTimePattern to change the default date format

Options

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<div id="pivot-container"></div>

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      data: getData(),
      mapping: {
        Date1: {
          type: "date string",
        },
        Date2: {
          type: "datetime",
        },
        Event: {
          type: "string",
        },
        Price: {
          type: "number",
        },
      },
    },
    slice: {
      rows: [
        {
          uniqueName: "Date1",
        },
      ],
      columns: [
        {
          uniqueName: "Date2",
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "Price",
        },
      ],
    },
    options: {
      datePattern: "yyyy.MM.dd",
      dateTimePattern: "yyyy/MM/dd HH:mm TT",
    },
  },
})

function getData() {
  return [
    {
      Date1: "2021-03-04T22:52:00",
      Date2: "2021-03-04T22:52:00",
      Event: "Concert",
      Price: 56,
    },
    {
      Date1: "2020-01-11T23:55:00",
      Date2: "2020-01-11T23:55:00",
      Event: "Performance",
      Price: 34,
    },
    {
      Date1: "2021-03-08T22:45:00",
      Date2: "2021-03-08T22:45:00",
      Event: "Cinema",
      Price: 10,
    },
  ]
}