Having difficulties displaying dates across different timezones. Used

Cyril over 12 years ago

Having difficulties displaying dates across different timezones.

Used 'usertimezone(pp!initiator)' to capture the initiator's timezone (stored in a text field).
When we display the dates in subsequent screens we use 'local (pv!datetime,timezone) This does not display the correct time.
Now store the dates as text - yes they display correctly, but now have a new problem.
We use the pv!date_time values for validation. If we hide the date_time fields validation fails, if we display date_time, validation works but we have confusion showing allt he dates.

How can we get one solution that will work?...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 12 years ago

ou need to combine the functions in this way for the following reason:

1. Date and Times are always stored in GMT in Appian
2. Date and Times are displayed in the user's timezone (the user that is viewing the data)
3. Date and Time functions always expect a value in GMT
4. In this case in the first part of the expression I use the gmt() function to find the GMT equivalent of the date time variable indicating to this function that the passed date and time has been already adjusted to the user's (who is viewing the form) time zone.

gmt(pv!myDateTime,usertimezone(loggedInUser()))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 12 years ago

ou need to combine the functions in this way for the following reason:

1. Date and Times are always stored in GMT in Appian
2. Date and Times are displayed in the user's timezone (the user that is viewing the data)
3. Date and Time functions always expect a value in GMT
4. In this case in the first part of the expression I use the gmt() function to find the GMT equivalent of the date time variable indicating to this function that the passed date and time has been already adjusted to the user's (who is viewing the form) time zone.

gmt(pv!myDateTime,usertimezone(loggedInUser()))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data