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.
can you please share where this very helpful parameter comes from and if there are any similar parameteres for Excel export that can help us with formatting and exporting different types of Pega properties?