Question

SharePoint read display datetime (not UTC)

  • 25 September 2019
  • 1 reply
  • 11 views
kathyjbryce
Rank
Badge +2

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

1 reply

jovitaatsafe
Rank
Userlevel 1
Badge +11

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? 

Reply


Community Stats

28,709
Posts
109,481
Replies
36,554
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.