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
+1
person also asked this
people also asked this
Replies
6 replies
Subscribers
10 subscribers
Views
8503 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
#Time Format, How to convert 12 hour time to 24 hour time? How
anilkumark
over 9 years ago
#Time Format,
How to convert 12 hour time to 24 hour time?
How to convert CST to EST. I am converting as below,
gmt(local(now(),"EST")). Time is changing fine, but the timezone is not changing. Still its displaying CST instead of EST.
Thanks in advance.
OriginalPostID-191649
OriginalPostID-191649
Discussion posts and replies are publicly visible
0
Lakshmi Meyyappan
over 9 years ago
Appian defaults to showing you the time in the timezone set by your local calendar/timezone settings. So when you run gmt(local(now(), "EST")) it should be changing the time value correctly but still displaying "CST" on the end. To correct for this, you may have to manually display the timezone, to do so you can use the text() function to display just the date and time and then concatenate "EST" to the end of the string.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Lakshmi Meyyappan
over 9 years ago
The "Date and Time Functions" page has more information about why this is the case:
forum.appian.com/.../Date_and_Time_Functions.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aviroop
over 9 years ago
Try this...
append(text(gmt(local(now(),"EST")), "mm/dd/yyyy hh:mm aa"), " EST")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
narasimhaadityac
A Score Level 2
over 9 years ago
@harshav, from expression given by "aviroop" kindly replace "aa" with "ss" if you want the format in 24 Hrs format.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
As 'ss' represents seconds, having it is optional and it won't influence 12 or 24 hours format. 'aa' shouldn't be used, as it appends AM to the time. So we can also just remove 'aa', rather than going for a replacement of it with 'ss'.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aviroop
over 9 years ago
Oh yes, I missed the first question. To convert 12 hour time to 24 hour, just remove aa part from my expression.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel