Forum Discussion

valariobr's avatar
valariobr
Regular Visitor
7 years ago
Solved

Day Light Saving Time affecting visualization

Last weekend started here in Brazil the Day Light Saving Time, and since then my reports dont show the date 04/11/2018, instead, appears 03/11/2018 23:00:00, even the datasource does not having time. I don't want that time or timezone be considerated in this field, only the date part, but even using some M function like DateTimeZone.RemoveZone when i try show the field in some visualization the problem still happens. Below I'll try ilustrate my problem.

 

In the left side are the dates in Excel, I the right side you can see the date 04/11/2018 imported.And now when I try to put the date field in some visualization, the 04/11/2018 disappears and shows up 03/11/2018 23:00:00.