Skip to main content
Question

Converting dates read from Microsoft Sharepoint

  • January 3, 2023
  • 1 reply
  • 36 views

femo
Contributor
Forum|alt.badge.img+6
  • Contributor

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
Evangelist
  • January 3, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings