How to specify DateTime format when I export excel file using pxGenerateExcelFile

User Experience
, ,
1

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).

yyyy HH:mm:ss format.jpg
yyyy HH:mm:ss format.jpg1108×187 19.2 KB

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
2

I set Param.EXCEL_DATE_TIME_FORMAT value before I execute pxGenerateExcelFile. And , I can specify DateTime format. Thank you.

3

@kobat Thank you!! Help a lot :smiley:

4

@kobat Hello Takefumi,

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?

Thank you very much.

Best regards,

Vadym