BUG: date string and timezones on DST changeover dates
Options
by ezk84
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="setTimezone()">Set timezone</button>
<button onclick="removeTimezone()">Remove timezone</button>
<div id="pivot-container"></div>
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 430,
toolbar: true,
report: {
options: {
datePattern: "dd/MM/yyyy",
dateTimePattern: "dd/MM/yyyy HH:mm:ss",
grid: {
type: "flat"
}
},
dataSource: {
type: "json",
data: [
{
"date":{"type":"date string"},
"n":{"type":"number"}
},
{
"date":"2020-10-03",
"n":1
},
{
"date":"2020-10-04",
"n":1
},
{
"date":"2020-10-03T00:00:00",
"n":1
},
{
"date":"2020-10-04T00:00:00",
"n":1
},
]
},
slice: {
rows: [{ uniqueName: "date" }],
columns: [{ uniqueName: "[Measures]" }],
measures: [{ uniqueName: "n" }],
}
}
});
function setTimezone() {
var options = flexmonster.getOptions();
options.datePattern = "GMT+10:dd/MM/yyyy";
options.dateTimePattern = "GMT+10:dd/MM/yyyy HH:mm:ss";
flexmonster.setOptions(options);
flexmonster.refresh();
}
function removeTimezone() {
var options = flexmonster.getOptions();
options.datePattern = "dd/MM/yyyy";
options.dateTimePattern = "dd/MM/yyyy HH:mm:ss";
flexmonster.setOptions(options);
flexmonster.refresh();
}