Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
4 subscribers
Views
2611 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
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?...
OriginalPostID-39381
OriginalPostID-39381
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