Is there away to control how a date value is displayed in a paging grid? The val

josephs over 10 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

Discussion posts and replies are publicly visible

Parents

0 Jorge Sanchez
Appian Employee
over 10 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 10 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