Skip to main content
  • EN

The field i would like to convert looks like this:

datetime_sharepointLooking at the same data via the Sharepoint GUI, the visible date is 04.08.2021.

How can i convert from the date above to the data in the GUI. I have been told, that the sharepoint date is GMT +00, while the GUI date ist GMT +01

I have already tried various datetime functions, but so far without success.

 

Thank you for your ideas!

Try this expression in a DateTimeCalculator set to Advanced:

@TimeZoneSet(@TimeZoneSet(@Value(ASK),utc),local)

This will first parse the timestamp as UTC, then convert to local time.

I'm sure there are other ways.

Reply


Community Stats

30,163
Posts
114,502
Replies
37,815
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.