Hello Everyone! We have a Tempo Report with 2 different flavors of Ex

preetamb

A Score Level 1

over 9 years ago

Hello Everyone!

We have a Tempo Report with 2 different flavors of Export Data to Excel-

1. An Export to Excel link allow users to export data to excel while being on the report interface
2. A Send Email button that sends email with the data attached.

We are using 'getdatasubsetdownloadlinkfromrule' for the export link and 'Export CDT To Excel' for Send Email functionality.

This report has few date fields. The default date format returned by 'Export CDT To Excel' smart service is 'dd-mmm-yyyy'.
But the export link on the report returns the default Appian date format which is 'mm/dd/yyyy'.

User's are experiencing an inconsistency in the date formats which we would like to address.
Any inputs on how we can resolve this issue to have the date format consistent across the interface?

Discussion posts and replies are publicly visible

Parents

0 shailendras593 over 9 years ago

Hi Preetam,

On way to do this is to create an expression rule to convert an input date into 'dd-mmm-yyyy' format and use this rule to change the format of your date fields, whenever you are generating the datasubset for the excel through getdatasubsetdownloadlinkfromrule plugin. A sample code for the rule :

concat(day(ri!inputDate),"-",month(ri!inputDate),"-",year(ri!inputDate))

But the CDT which you are using for export should have all those date fields as 'text' data type (to accommodate a value of 'dd-mmm-yyyy' format). For this, you can make a temporary CDT and use that in place of the original one while generating the datasubset for Excel.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 shailendras593 over 9 years ago

Hi Preetam,

On way to do this is to create an expression rule to convert an input date into 'dd-mmm-yyyy' format and use this rule to change the format of your date fields, whenever you are generating the datasubset for the excel through getdatasubsetdownloadlinkfromrule plugin. A sample code for the rule :

concat(day(ri!inputDate),"-",month(ri!inputDate),"-",year(ri!inputDate))

But the CDT which you are using for export should have all those date fields as 'text' data type (to accommodate a value of 'dd-mmm-yyyy' format). For this, you can make a temporary CDT and use that in place of the original one while generating the datasubset for Excel.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data