Skip to main content
M
maguntajishnur2456
July 24, 2024
Question

Timezone Conversion

  • July 24, 2024
  • 7 replies
  • 0 views

Hi Guys,

I Have a requirement where the user will enter the date&time(date&time component) and the timezone(given in the dropdown). I want it to be converted based on the timezone user has given which in turn has to be converted again to GMT and be stored in the database, but in the screen level i want to display whatever the user has entered without any conversion. Is this achievable ?

    7 replies

    venkatrea696188
    venkatrea696188
    July 24, 2024

    Appian does this Automatically You don't need to do anything. When it's writing it to DB Appian Uses UTC, When you are Querying back and showing it in Appian it Uses Default timezone of User.

    If you want to convert it to Someother timezone Use Local()

    M
    maguntajishnur2456Author
    July 24, 2024

    Ok thank you

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 24, 2024

    https://appian.rocks/2023/02/13/working-with-time-in-appian/

    alia9409
    alia9409
    July 30, 2024

    You can use the gmt() function to set the prefered timezone or create a dropdown list.

    gmt(now(),"EST"),
gmt(now(),"EDT"),
gmt(now(),"GMT-05:00"),

    Terms & ConditionsAccessibility statement