To display date and time from Database to Appian irrespective of user Time zone

Certified Senior Developer

Hi All,

We wrote a query to fetch  date from one particular entity from Database, but the output(date) differs based on the user time zone.

For example ,

In Database it shows as 10th June 2021,12:06 AM,

For GMT time zone user it shows as 10th June 2021,12:00 AM as output in expression rule,

For EST time zone user it shows as 9th June ,8:00 PM as output in expression rule.

Can you please help us to sort this, Thanks in Advance.

Regards,

Jansi J

  Discussion posts and replies are publicly visible