Question

1
Replies
78
Views
pravalikak Member since 2018 2 posts
S & P Global Company Ltd
Posted: 6 months ago
Last activity: 5 months 3 weeks ago

pxGenerateExcelFile exporting datetime for a date property pega 8.2.2

Hi Team,

 

Using pxGenerateExcelFile for exporting to excel by giving datapage as a source, is exporting datetime value for a date property and date is getting delayed by one day. This is happening if the server timezone is EST, and we tried changing timezone to UTC, we are able to see accurate results,but we cannot modify server timezone .

Applied Solutions: Called UpdateLocaleSettings and tried to set timezone, it didn't work.

 

Upon click of button , calling OpenURLInWindow--> activity--> ExportWLDataToExcel--> Call pxGenerateExcelFile. 

 

I have attached all the images such as : UI, Actions on Download button in below snapshot, DB data, Server Timezone, OperatorTimezone, Clipboarddata to the related SR: SR-D79395.

 

We aren't receiving any proper response from SR-D79395. Kindly if any expert have an alternative solution would be helpful.

 

 

In the UI, we are able to see  dates as 29thNov, 14thFeb as highlighted, 

UI

After Exporting to Excel, results are as below:

 

ExportedExcel

Any expedite solution would be highly appreciable.

 

Thank you.

 

 

***Edited by Moderator Marissa to update SR Details***

Pega Platform 8.2.2 Low-Code App Development Upgrades Financial Services System Architect SR Exists
Share this page LinkedIn