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
5 replies
Subscribers
5 subscribers
Views
2099 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Hello Everyone! We have a Tempo Report with 2 different flavors of Ex
preetamb
A Score Level 1
over 8 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?
OriginalPostID-204746
OriginalPostID-204746
Discussion posts and replies are publicly visible
Parents
0
shailendras593
over 8 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 8 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