Hoping one you guys are M/Power Query gurus…
So my data source is a SharePoint Online list and the dates are pulling through incorrectly, seems to be a none problem.
Where ever there’s a date that has 23:00:00 it should show the next day which would be 19/09/2018
, if its shows 00:00:00 then the date is correct so it would be 18/09/2018
I’ve changed SharePoint time zones, tried If then and else M query but can’t seem to crack it.
Maybe a custom function would do it??
Thanks for any help