Forum Discussion

Lopez0090's avatar
Lopez0090
Icon for Helper III rankHelper III
5 years ago
Solved

Mquery to change datatime to localtime

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 kn...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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