Skip to main content
maguntajishnur2456
Known Participant
Jul 24, 2024 5:12 PM UTC
Question

Timezone Conversion

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
    Inspiring
    Jul 24, 2024 5:26 PM UTC

    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()

    maguntajishnur2456Author
    Known Participant
    Jul 24, 2024 5:39 PM UTC

    Ok thank you

    alia9409
    alia9409
    Participating Frequently
    Jul 30, 2024 4:45 PM UTC

    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