Hi All, My first post, so apologies if this has been already asked, but i could not find a solution to this.
In my sharepoint list the dates are correct
but when imported they are imported to my power query they are a day behind with time attached to it.
I have seen post to manually add a column to reduce it by one day but I have many many tables and each has date column so its too much.
Why is it behaving in such way.
Please advise.
It does that because your SharePoint dates are coming in as UTC. You can bring them in as datetimezone to start/confirm and then convert them in added steps from there.
Pat