Question
Verizon Global Services pvt Ltd
IN
Last activity: 25 Mar 2020 11:09 EDT
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:
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***
Pegasystems Inc.
US
It looks like the stored date is being converted from GMT to the locale of the operator (EST/EDT?).
Try adding a non-autogenerated format to the columns in the report definition that will output the GMT date.