Question3Replies201Views×Close popoverMahendra Chennaipalem (MahendraC4119) Infosys Infosys IN View ProfileSend Message MahendraC4119 Member since 2017 3 posts Infosys Posted: March 7, 2019Last activity: March 12, 2019Posted: 7 Mar 2019 8:20 ESTLast activity: 12 Mar 2019 7:50 EDT 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-pagelist-excel***Edited by Moderator Marissa to update platform capability tags**** Low-Code App Development Reporting User Experience ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post, learn more×Close popover 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: 2 years agoPosted: 8 Mar 2019 1:41 EST×Close popoverMounica Gudaboina (gudam) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileSend Messagegudam 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-exported-excel-differs-report-date-format https://community.pega.com/support/support-articles/export-excel-date-format-incorrect https://community.pega.com/support/support-articles/date-format-displays-incorrectly-when-exporting-data-excel Also your issue 1 and issue 2 are same, check if you wrongly mentioned. Thanks! Posted: 2 years agoPosted: 8 Mar 2019 6:52 EST×Close popoverMahendra Chennaipalem (MahendraC4119) Infosys Infosys IN View ProfileSend MessageMahendraC4119 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 agoPosted: 12 Mar 2019 2:00 EDT×Close popoverMahendra Chennaipalem (MahendraC4119) Infosys Infosys IN View ProfileSend MessageMahendraC4119 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.