Question

Converting dates read from Microsoft Sharepoint

  • 3 January 2023
  • 1 reply
  • 7 views
F
Badge

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!

1 reply

david_r
Rank
Userlevel 4

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

28,669
Posts
109,362
Replies
36,531
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.