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
I have a json format where I have only one column for value(which is of text datatype) to which I will be saving all the values.
Is there any way to achieve this in text datatype?
We could use a little more detail of course - like what your data structure looks like, how exactly you're capturing the datetime value and then converting it to json (and where the json is sourced from if there are any additional non-appian-input sources).
But based on testing i'm doing right now, it looks as if a dateTime value captured into an appian dateTime entry field and then stored into JSON text, automatically converts to GMT. If you're converting it back from JSON later to a dateTime data type, it should then automatically display in a user's chosen timezone, without much additional overriding necessary.
I'm also finding this one. Is it possible to store the date in to any other timezone?
Hi Mike,
For example, am using a dateAndTime component and am using datatype of text to save it. On doing so, my value will get saved as "4/1/2022 11:46 AM CDT". On retrieving it from DB, the same value will be retrieved. Is there any way to save the dateTime value in GMT format(as am using Text datatype) to DB and retrieve it, so that based on usertime zone dateTime value will be changed.
Or is there any other way other than saving the value as GMT, any functions?
Can you share the expression / interface you have created? In general the converting works pretty well between different time zones, but I'm wondering if there is somewhere you are explicitly saving the time zone as text and that's why it isn't converting back and forth.
Hi Peter,
Please find the snippet below,
Here I have the value as "4/4/2022 10:43 AM CDT" which is in CDT timezone and am having it in Text datatype. I wanted this date and time to be converted based on user timezone. Now am currently in UK timezone, am expecting the value to be 4/4/2022 4:43 PM GMT+01:00, but my output is something else.
mpa17 said:am using a dateAndTime component and am using datatype of text to save it
Why are you doing it this way? I strongly suggest you store it as a data type of date/time instead.