Skip to main content
fantacyc0001
fantacyc0001
August 2, 2021
Question

How can I convert the rule inputted date time into current logged user's date time?

  • August 2, 2021
  • 3 replies
  • 0 views

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.

3 replies

stefanhelzle0001
stefanhelzle0001
Brainy
August 2, 2021

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.

fantacyc0001
fantacyc0001Author
August 3, 2021

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.

stefanhelzle0001
stefanhelzle0001
Brainy
August 3, 2021

On a technical layer, systems should always communicate in gmt.

Terms & ConditionsAccessibility statement