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
  • femoContributor
  • 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
Celebrity
  • david_rCelebrity
  • 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


Helpful Members This Week

Community Stats

31,223
Posts
118,401
Replies
38,824
Members

Latest FME

Terms & ConditionsCookie settings

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
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.