Dear Experts,
There is a requirement that, a given date time, which maybe GMT+05, GMT, or GMT-03, we need convert it to logged user's time.
For example, given date time is "7/29/2021 2:39 AM GMT+05:00", my local time zone is "GMT+08", I need convert it to local time, the expected result should be "7/29/2021 5:39 AM GMT+08:00".
However, I have tried below functions ( image attached ), no one can meet my expectation.
Discussion posts and replies are publicly visible
Where is that timestamp coming from? In general, gmt() subtracts time offset and local() adds it. Combining both should do the job. But, Appian will DISPLAY the timestamp in your locale. This means it sometimes is difficult to understand what is actually going on.
Hello Stefan,
This timestamp come from external system, we get from integration object. as you said Appian is difficult to understand the time zone from inputted date, then we have a solution that request external system pass us the gmt time, and Appian will Display it in the local time zone, then issue resolved, thanks for your support.
On a technical layer, systems should always communicate in gmt.