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 .
***Edited by Moderator Marissa to update Platform Capability tags****
@KRISHKY 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.
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.