I have an issue with getting correct datetime value from the pivot table.
I passed column with datetime type to pivot and it displayed as expected. But when I try to display the same data on a Highcharts I get NaN or date (but with wrong time zone)
Please see an example https://jsfiddle.net/hxuc4ver/
Thank you for posting to our forum.
Our team is currently working on your case.
We will reach out to you as soon as possible.
Thank you for giving us some time to investigate your case.
Testing your example, we discovered that defining
report.options.dateTimePattern fixes the issue with
NaN values. Speaking of timezones, we would like to kindly inform you that using JS functions, the timestamp can be converted to the date with any desired timezone.
For example, to remain your ‘datetime’ values the same as in the dataset, you can convert the timestamp to the Date Object and then use the
Our team modified your example to illustrate the mentioned approaches: https://jsfiddle.net/flexmonster/8d25qxcs/.
dateTimePattern to the report and the timestamp conversion in the
Please let us know if it helps.
Waiting for your reply.
Thanks for your help.
I see that your solution to fix NaN doesn’t work with dateTimePattern like ‘dd/MM/yyyy HH:mm:ss’
Could it be fixed?
Thanks once again.
Further to previous message. I’ve checked all available date formats that used In my application. Here is a list of problematic formats:
Thank you for reporting the issue with
dateTimePattern and some date formats.
Our team is going to provide the update with the fixes ETA 8 Feb.
We will notify you as soon as the new version is released.
Please let us know if any additional questions arise.
We are happy to let you know that the issue with
getData() output when working with dates was fixed.
This is available in the 2.8.26 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component.
Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if everything works.
Our team is wondering whether the recent fix helped.
Please let us know if everything works fine.
We are looking forward to hearing from you.