Question

Date gets Changed after performing Export to Excel

Hi,

We are using Pega 7.2.2 and we have a datetime type property which gets changed after performing export to excel (Calling pzRDExportWrapper activity). For e.g the date was put in MM/DD/YYYY format as 12/3/2019 however in excel it appeared as 3-19-2012. Please find attached the word document for more details

***Edited by Moderator: Lochan to update platform capability tags***

Group Tags

Correct Answer
December 4, 2019 - 12:11pm

Hi Anand,

This is a bug in pega.It has been resolved by hfix-37092.Please raise a SR to get this hfix.

Thanks,
Abhinav

Comments

Keep up to date on this post and subscribe to comments

December 2, 2019 - 9:42pm

Hi Anand,

Are you facing the same issue when you are trying to export the RD data to pdf?

Is this issue specific to an operator or consistent for all users? If specific to any operator then what is the locale and timezone setting for this operator?

Is it a Date property or DateTime property?

Could you please attach the presentation tab of the cell property?

Regards,

Vikash

December 3, 2019 - 12:44pm
Response to Vikash Karn

Thanks Vikash for quick reply. I am not getting this issue when I am creating Report definition and exporting to excel.

This issue is consistent for all users. Default locale is set as English/United States, however I have tried changing the locale but it only changes the format. In my issue I think the date itself is getting changed as you can see the year is coming as 2012.

It's a datetime property, however in presentation i am changing it to date. Please refer to the attachment for more details.

Please note this is working fine on Pega 8.3.1

Pega
December 4, 2019 - 12:11pm

Hi Anand,

This is a bug in pega.It has been resolved by hfix-37092.Please raise a SR to get this hfix.

Thanks,
Abhinav

December 6, 2019 - 11:33am
Response to Abhinav7

Thanks Abhinav! The issue is fixed after applying the hotfix.

December 4, 2019 - 3:05pm

Please let us know your SR ID when you open it so we can track this for you.

Thanks!

Marissa | Community Moderator | Pegasystems Inc.

December 6, 2019 - 9:46am
Response to MarissaRogers

Thanks Marissa! Raised SR-D67390.