Question
Infosys
IN
Last activity: 12 Mar 2019 7:50 EDT
Data Type is converting to text when exporting pagelist results to Excel
I am calling the below activity from another activity by passing the file name and Binary file(rule) and able to generate excel from UI.
call MSOGenerateExcelFile
Issue-1:
Date column value in the generated excel is MM DD,YYYY HR:MM:SS AM/PM but we want it in MM/DD/YYYY HR:MM AM/PM.
Issue-2:
Date column value in the generated excel is MM DD,YYYY HR:MM:SS AM/PM but we want it in MM/DD/YYYY HR:MM AM/PM.
Please suggest me . It is very urgent issue.
Related post: https://community1.pega.com/community/pega-support/question/export-data-pagelist-excel
***Edited by Moderator Marissa to update platform capability tags****