Mquery to change datatime to localtime

[Lopez0090]

The date captured in the Sharepoint list was different from the time actually displayed on the PC.
I want to change it to local time in the Query Editor, but I don't know how.

If anyone knows how to do this, could you please let me know?

[Vera_33 · Accepted solution]

Hi @Lopez0090 

It depends on what the time difference you want to switch, have a look at DateTimeZone functions in M:

DateTimeZone.SwitchZone

DateTimeZone.ToUtc

DateTimeZone.ToLocal

[Lopez0090]

@Vera_33 

Thank you for your advance!!