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
4 replies
Subscribers
4 subscribers
Views
2301 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Is there away to control how a date value is displayed in a paging grid? The val
josephs
over 9 years ago
Is there away to control how a date value is displayed in a paging grid? The value is being retireved in a "Date and Time" format using the Query Database node. From the the value is displayed in "Date" format column in the Paging Grid and is displaying a time with the GMT offset.
If possible I would like to display just the date. Otherwise display the Date and Time with the correct timezone which is EST.This is version 7.2
The process is used over multiple timezones and the we do not have the option to set individual timezones
Thanks for any help.
Attached image shows current display....
Date Screenshot.docx
OriginalPostID-135043
OriginalPostID-135043
Discussion posts and replies are publicly visible
Parents
0
Jorge Sanchez
Appian Employee
over 9 years ago
try using the fn!datetext() function... for example:
datetext(pv!myData, "MM/dd/yyyy hh:mm:ss z")
MM: Month
dd: day
yyyy: Year (2 or 4 digits are valid)
hh:Time in 12 hours format (use HH for 24 hour format)
mm: minutes
ss: seconds
z: timezone in standard format as defined by the system
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Jorge Sanchez
Appian Employee
over 9 years ago
try using the fn!datetext() function... for example:
datetext(pv!myData, "MM/dd/yyyy hh:mm:ss z")
MM: Month
dd: day
yyyy: Year (2 or 4 digits are valid)
hh:Time in 12 hours format (use HH for 24 hour format)
mm: minutes
ss: seconds
z: timezone in standard format as defined by the system
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data