Skip to main content
Question

Converting UTC to Local Time, error by 2hr

  • April 6, 2020
  • 1 reply
  • 53 views
benvk
Contributor
Forum|alt.badge.img+8
  • benvkContributor
  • Contributor
  • 60 replies

I am downloading my survey123 data from ArcGIS Online Feature Layer, and trying to convert the stored UTC into Local Time, and I have been provided this code, from this thread: 

@TimeZoneSet(@TimeZoneSet(@Value(shift_start),local),utc,convert)

 

It initially looked good, but now I am looking closer at the results I am seeing the converted data is all out by +2hr. Where I should be seeing it converted to 8.30am,  they are all showing as 10.30am. 

And today we have started 'daylight savings' where we adjust our clocks by 1hr, my dates are instead showing as +4hr out! I am pulling my hair out as I have no idea where to start looking to resolve!

I am unsure why this could be? Is there an adjustment I should be making? Is it a setting in FME? I am in Sydney Australia time zone.

    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

    ebygomm
    Influencer
    Forum|alt.badge.img+44
    • ebygommInfluencer
    • Influencer
    • 3427 replies
    • April 6, 2020

    That expression converts from local to utc, you  need to convert from utc to local

    @TimeZoneSet(@TimeZoneSet(@Value(shift_start),utc),local,convert)

    Community Stats

    32,076
    Posts
    121,797
    Replies
    39,707
    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.