Data with datetime – interpreted with localisation
Hi, I am returning data from my database which has the local datetime. The JSON data being returned is for example:
In the above, the time is 01 Aug 2017 00:15.
I would like the chart to interpret it as 01 Aug 2017. However, it’s being rolled up to 31 July instead of 01 Aug. I have now realised that it’s perhaps taking my local time zone to interpret it as being on 31st July 2017 GMT.
How can I get the data to interpret the time AS-IS?
For now my only option is to add some offset in the time in my query. but I don’t know what will happen for other users running the report with different localisation.
Thank you for writing to us.
As an input date format, pivot table component supports ISO 8601 date (other formats may be used, but results can be unexpected).
Could you please try to use the following format
Z after minutes and let us know if this helps?