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
5 replies
Subscribers
7 subscribers
Views
4224 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Hi.. How to convert datetime from GMT to user's local timestamp? i.e 25/06/2
Sharmila Nagaraj
A Score Level 1
over 9 years ago
Hi.. How to convert datetime from GMT to user's local timestamp? i.e 25/06/2015 01:00 GMT+01:00 has to be displayed as 25/06/2015 01:00
OriginalPostID-154436
OriginalPostID-154436
Discussion posts and replies are publicly visible
0
sonalk
over 9 years ago
Hi Sharmilan,
Try the text function passing with the user's local time stamp as rule input as shown below :
text(ri!datetime,"dd/mm/yyyy hh:mm")
Hope it helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
gauravg568
over 9 years ago
You may find local expression function of benefit.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
martinm
over 9 years ago
For the text() function, the datetime should automatically display the user's local timezone (or the Primary Timezone in the Internationalization Settings, if the user's timezone is not set). If needed, you can also use the local() function to offset the datetime (
https://goo.gl/e0pn9c)
.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
davidm415
over 9 years ago
There are probably a number of ways to do this, but I was able to get something similar to what you are looking for by doing:
datevalue(pv!dateTime)&" "&time(pv!dateTime)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
gauravg568
over 9 years ago
forum.appian.com/.../Date_and_Time_Functions.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel