Close popover
pravalika kamisetti (pravalikak)
S & P Global Company Ltd

S & P Global Company Ltd
pravalikak Member since 2018 2 posts
S & P Global Company Ltd
Posted: March 6, 2020
Last activity: March 25, 2020

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, 


After Exporting to Excel, results are as below:



Any expedite solution would be highly appreciable.


Thank you.



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

Pega Platform 8.2.2 System Administration Upgrades Financial Services System Architect Support Case Exists