Question

1
Replies
46
Views
Takefumi Kobayashi (kobat)
PEGA
Senior System Architect
Pegasystems Inc.
JP
kobat Member since 2020 6 posts
PEGA
Posted: July 30, 2021
Last activity: August 1, 2021
Posted: 30 Jul 2021 0:19 EDT
Last activity: 1 Aug 2021 22:58 EDT
Solved

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).Datetime property is displayed in MM/dd/yyyy HH:mm:ss format.

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 Japan
Pega Platform 8.5.1 User Experience Senior System Architect