Posted: 3 Dec 2018 16:28 EST Last activity: 2 Jan 2019 10:59 EST
MSOGenerateExcelFile exports the excel with datetime fields as 20170921T180901.000 GMT
I'm using Pega 7.2.2 and I was using MSOGenerateExcelFile by creating a template and exporting the results of a report definition to excel sheet. The results are getting exported successfully but the fields with datetime gets exported as xxxxx GMT and not as 4/12/2018. Is there any better way of achieving this?
***Moderator Edit-Vidyaranjan: Updated SR details***