Question
Evonsys
IN
Last activity: 19 May 2021 6:01 EDT
MSOGenerateExcelFile export Datetime to format dd/MM/yyyy
How to use MSOGenerateExcelFile export DateTime to format dd/MM/yyyy HH:mm:ss?
I want to export data from report definition with OOTB Function "MSOGenerateExcelFile", Then I have problem when I export with DateTime Properties. It's always export DateTime properties in format GMT.
i also refer the previous suggestion , but it wont work .
Cognitonic Systems Australia
AU
@GopalakrishnanIyyavu Once data is retrieved loop the page list using the FormatDateTime function and change the date format and then execute MSOGenerateExcel on the Pagelist.
The below link matches your requirement:
https://collaborate.pega.com/question/how-get-formatted-date-xlsx-file
Other links that might be useful:
https://community.pega.com/support/support-articles/when-exporting-excel-date-format-yyyymmdd
Cognitonic Systems Australia
AU
@GopalakrishnanIyyavu Yes once RD is executed, we can loop the pagelist and then value can be formated.
Steps to achieve:
1. Create an activity that will first call the RD which retrieved results on a Page.
2. Loop the list and format the datetime value and assign that to any Text or date property.
3. Once iteration is done generate excel using pxGenerateFile/MSOGenerateExcelFile by specifying the step page.
Alternative approach:
Try leveraging Column format option against the column in RD. Specify Export_DateTime/Export_Date controls in column formats. When we download the file the file will be downloaded with this formats dd/mm/yy for Export_Date control. For custom format saveas the control and replace (PRDateFormat.DEFAULT_DATE_SHORT) with your specific format.