Question
1
Replies
546
Views
Posted: March 15, 2019
Last activity: March 15, 2019
Closed
How to use MSOGenerateExcelFile export Datetime to format dd/MM/yyyy HH:mm:ss
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.
Thank you.
***Edited by Moderator: Pallavi to update platform capability tags***
Please check the below links
https://community1.pega.com/community/product-support/question/how-get-formatted-date-xlsx-file
https://community1.pega.com/community/pega-support/question/msogenerateexcelfile-exports-excel-datetime-fields
https://community.pega.com/support/support-articles/when-exporting-excel-date-format-yyyymmdd