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
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
0
Jorge Sanchez
Appian Employee
over 9 years ago
Forgot to add, if used in a grid, you will need to use the apply function in the gridTextColumn, for example:
a!gridTextColumn(
...
data: apply(
fn!datetext(_, "MM/dd/yyyy hh:ss"),
index(local!gridData.data,"myDate",null),
...
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jamie Loizou
Appian Employee
over 9 years ago
I have also found that the text() function is a more robust substitute for the datetext() function in terms of its ability to gracefully accept null parameters.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
pavithrac
over 9 years ago
Hi josephs,
This is pretty much possible even in 7.2
we can go with either of the below functions:
1) =text(todate(ri!dateTime),"dd/mmm/yyyy")
2) =index(split(ri!dateTime," "),1)
since its version 7.2, we need to create a dummy cdt same as the cdt which we want to show in paging grid with the dateTime fields as text. Now we need to desine the variable with the dummy CDT type in our process model.Then we need to save each column in this dummy cdt in a script task by apply any of the above functions to the "dateTime columns".This is because we need to show dateTime as Date in required Format in paging Grid.Now we can simply use the Dummy CDT to display the data in our paging grid.
hope this helps......Also find the screen shot of which i have created the scenario and displayed in a form
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel