Skip to main content
Question

SharePoint read display datetime (not UTC)

  • September 25, 2019
  • 1 reply
  • 44 views
kathyjbryce
Contributor
Forum|alt.badge.img+3

I have a SharePoint list that displays local datetime from many different local time zones, this is the datetime required. The reader returns datetime fields in UTC only. The time offset could be 6 to 8 hours. I have no way to know what local timezone the records was entered in, thus I cannot determine what the time offset should be. Is there a way to read the displayed datetime, not UTC?

For example, two records with different time offsets

Sharepoint

Value read by FME

Formatted

Offset

9/14/2019 21:00

20190915030000+00

9/15/2019 3:30

6 hours

2/14/2019 21:55

20190215045500+00

2019/02/15 4:55

7 hours

Thanks in advance,

Kathy

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

jovitaatsafe
Safer
Forum|alt.badge.img+11
  • jovitaatsafeSafer
  • Safer
  • September 30, 2019

Hi @kathyjbryce,

I confess i'm not a SharePoint expert but I did notice something in the SharePoint reader documentation under DateTime Field Type that I think might help. According to the doc:

SharePoint stores values in UTC time zone only.
The SharePoint web interface adjusts values to the local time zone.
The SharePoint reader converts values to FME datetime format.

So it is expected behavior for FME to convert the local time zones into UTC on read. Have you taken a look at the DateFormatter by chance as a potential solution? 

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.