Skip to main content
P
poojad0001
June 23, 2021
Question

TimeZone Changes during day light saving

  • June 23, 2021
  • 8 replies
  • 0 views

HI,

Does appian takes care of Day-light saving when the time changes in winter?

    8 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 23, 2021

    Yes. Internally Appian is using UTC only. When a date&time is used or shown to the user it is translated into the users timezone including daylight saving.

    P
    poojad0001Author
    June 24, 2021

    [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] Thank you for your response.

    Could you please help us to know if it still works in below scenario?

    Appian implementation:

    How GMT is exported to XML text as BST:

    datetext(local(gmt(ri!trDetails.crdate,"America/New_York"),"Europe/London"), "MM/dd/yyyy HH:mm:ss")

     

     

    How we save date and time based on user input in DB:

    local(save!value,"America/New_York")

     

    How we get GMT date and time based on value in DB:

    gmt(local!itemObj.callbackts,"America/New_York")

     

    Please note that:

    users are not able to change default time zone which is setup as America/New_York

    There is no timezone setup for each process model (left empty) and we do not override with process initiator time zone.

    Process model Properties

     

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 24, 2021

    As I already explained, Appian manages time zone translation between UTC internally, this includes DB, and the user.  Cases 2 and 3 just work. Do not add any timezone calculations on top of what Appian is doing.

    Regarding the XML. Is that necessary? The question whether it works ... difficult. The issue is that even in expression designer, Appian still tends to do this kind of translation. So what you see on screen might be not the actual values.

    Converting into another timezone should be simple: local(gmt(now()), "America/New_York")

    davel001150
    davel001150
    July 8, 2021

    In other words, why is ANYTHING in NAM timezone? Convert everything to UTC timezone, the DB and the Appian instance, then find the setting to allow all the users to set their own timezones for display.  Everyone can see whatever times they want, and all the times will be consistent in the App and the DB.

    Terms & ConditionsAccessibility statement