Formatting a specific date field using the mapping

Mapping configuration

by Flexmonster Pivot Table

HTML

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

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

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      data: getData(),
      mapping: {
        "DeliveryDateTime": {
          type: "datetime",
          caption: "Delivery date"
        },
        "OrderDateTime": {
          type: "datetime",
          format: "GMT+6:dd/MM/yyyy HH:mm:ss",
          caption: "Order date"
        }
      }
    },
    slice: {
      rows: [
            {
                uniqueName: "OrderDateTime"
            },
            {
                uniqueName: "DeliveryDateTime"
            }
        ],
        columns: [
            {
                uniqueName: "[Measures]"
            }
        ],
        measures: [
            {
                uniqueName: "Price"
            }
        ]
    },
    options: {
    	grid: {
      	type: "flat"
      },
      dateTimePattern: "MMM d, yyyy, h:mm:ss TT",
      dateTimezoneOffset: +5
    }
  }
});

function getData() {
  return [
    {
      "DeliveryDateTime": "2021-03-04T22:52:00",
      "OrderDateTime": "2021-03-04T22:52:00",
      "Price": "234"
    },
    {
      "DeliveryDateTime": "2020-01-11T23:55:00",
      "OrderDateTime": "2020-01-11T23:55:00",
      "Price": "125"
    },
    {
      "DeliveryDateTime": "2021-03-08T22:45:00",
      "OrderDateTime": "2021-03-08T22:45:00",
      "Price": "936"
    }
  ]
}