Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Convert Date modified to local timezone

Hello,

 

I want to get the modified date and time of an Excel file stored in a SharePoint folder. I was able to do it via Power Query but the problem is the modified date and time are always shown as UTC, and i want to convert it to Western Europe time which is currently UTC+1 in winter and in summer, it is UTC+2 due to DST. Is that possible?

 

Currently, this is what i see in Power Query:

 

If i select the Date/Time/Timezone:

I get this:

But will the time automatically adjust for summer due to DST? And is the time shown dependent on the configuration settings of the user's browser, etc?