Posted: 6 Mar 2020 1:01 EST Last activity: 25 Mar 2020 11:09 EDT
pxGenerateExcelFile exporting datetime for a date property pega 8.2.2
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.
***Edited by Moderator Marissa to update SR Details***