Hi Everyone,
I have a situation, i want to show the a constant timezone to every user no matter user is from USA, Canada or india, every user should see a constant date and time ,
No matter user changes his timezone in appian setting , timzzone should be remain same, changes in timezone in appian setting should not impact interface setted timezone,
For exmaple:
In the I created a record at 13 Sept 2024 12:11 AM IST ,
but i want to show on the inferface 12 Sept 2024 11:41 PDT,
i implement a code when i set my timezone in appian setting as India Standard Time (IST) but when i change my time to PST in appian setting it impacts on interface as well
text( todatetime( gmt( text( gmt(fv!row.createdOn, "750"), "mm/dd/yyyy hh:mm AM/PM" ), ) ), "MM/dd/YYYY HH:MM AM/PM" )
Discussion posts and replies are publicly visible
Please try this
a!localVariables( local!time:now(), text(gmt(local!time),"mm/dd/yyyy hh:mm AM/PM" ))
The gmt(local!time) value for different timezone were
Pacific Time - 9/16/2024 2:45 PM PDT
Easter Time - 9/16/2024 2:45 PM EDT
Indian Standard Time - 9/16/2024 2:45 PM GMT+05:30