February 2019 Entries

Power BI – Fixing Dates from Sharepoint Lists (converting UTC Dates to Local Dates)
So the problem below was in relation to working with dates from a Sharepoint 2013 List, but the same technique should be applicable any time you want to convert UTC/GMT datetime fields to a local time. When Sharepoint exposes datetime values from lists using its REST API it converts them to the UTC timezone. I suppose a lot of the time this makes sense, specially if you are dealing with data entry across multiple time zones. But if you are just working in a single timezone this can be frustrating ......

Posted On Friday, February 1, 2019 2:22 PM | Comments (0)