How to specify DateTime format when I export excel file using pxGenerateExcelFile
Hi,
I want to export Excel file using pxGenerateExcelFile activity. I create excel template and use Datetime property in the template. I expect that Datetime property is displayed in yyyy/MM/dd HH:mm:ss format in excel. But, actually, Datetime property is displayed in MM/dd/yyyy HH:mm:ss (I attached image).
Could you teach me how to specify DateTime format when I export excel file using pxGenerateExcelFile? And, I do not want to convert Datetime value to "String" value in yyyy/MM/dd HH:mm:ss format.
And, my Localization setting of operator id is below.
- Default locale is ja_JP
- Time zone is Asia/Tokyo