Question3Replies178Views MahendraC4119 Member since 2017 3 posts Infosys Posted: 1 year agoLast activity: 1 year 7 months ago Closed Solved Data Type is converting to text when exporting pagelist results to ExcelI 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 MSOGenerateExcelFileIssue-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…***Edited by Moderator Marissa to update platform capability tags**** Low-Code App Development Reporting User Interface ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year agogudam PEGA replied to MahendraC4119Hello Mahendra, Please review the below articles whose issue seems to be same as yours: https://community.pega.com/support/support-articles/date-format-exporte… https://community.pega.com/support/support-articles/export-excel-date-f… https://community.pega.com/support/support-articles/date-format-display… Also your issue 1 and issue 2 are same, check if you wrongly mentioned. Thanks! Posted: 1 year agoMahendraC4119 Infosys replied to gudamI am taking the PAGE LIST properties to EXCEL using Binary File. But how can I use the report definition to resolve the date format issue. Accepted Solution Posted: 1 year agoMahendraC4119 Infosys replied to MahendraC4119This issue is resolved . Created the new text property and did the data manipulation on the string in data transform to get the format we need.