Forum Discussion
Solved
Date 1 day behind source date
I am importing various date fields from a SharePoint site - however, every date shows the previous day. The SharePoint time zone is set for UTC Dublin, Edinburgh, Lisbon London and the locale En...
I have another option for a solution that I've used. I have a date/time/timezone column that has 00:00:00 UTC as the time component and I only want to extract the date, not fussing with timezones.
What I did was to convert the column to text, ex.
2025-01-08T00:00:00Z
Then use the following to strip out the date before the time component by using the T as a delimiter:
=Text.BeforeDelimiter([Start DateTime], "T")
Then convert this column to a Date type. This makes sure there is no timezone interfering with the date value.