Forum Discussion
Date field missmatch
Currently, when dates are converted to ISO dates, we add a time component too (midnight).
eg. 01/11/2014 -> '2014-11-01T00:00:00.000Z'
This is fine for dates fall in winter (before clock change). However, dates fall in the summer (BST), conversion off set 1 hour making the midnight of a day to the 11PM on previous day.
eg. 01/04/2014 -> '2014-03-31T23:00:00.000Z'
2 Replies
The Z here means ZULU, or UTC. If you use UTC timestamps throughout your data then that is not impacted by DST changes.
In ISO8601 you can also specify the UTC offset as needed.
Hi Anonymous ,
Please first convert the data type of these columns to Date/Time in Query Editor.
You can refer to these thread:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
