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

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data