Hi All,
I have a use case where I need to convert Date and time based on user time zone.
I have a date and time component, and if user of timezone CDT selects date and time as "4/1/2022 11:46 AM CDT" and submits the case. If another user of time zone IST logs in then they should be able to see the date and time value as "4/1/2022 10:16 PM IST" (whatever the usertime zone is). Based on user time zone date and time value needs to be changed in UI.
I have tried with todatetime(), gmt() and usertimezone() functions but none of them works.
Please provide your suggestions.
Thanks
Discussion posts and replies are publicly visible
Technically this should work out of the box if you are using the https://docs.appian.com/suite/help/22.1/Date_and_Time_Component.html without any manipulation.
Date should be stored as GMT in the database and is displayed according to the user's preferred timezone.
Hi Mathieu,
Thanks for the reply!
Tried by saving date as GMT, but it is resulting in some other date and time.
Not sure what you mean by "tried saving as GMT". You shouldn't have to transform it before saving.
There is no need to "try" saving as GMT - appian stores dates/times internally as GMT.