Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Satya Kanth (Satyakanth)
Virtusa
Satya Kanth
Virtusa
AU
Satyakanth Member since 2012 47 posts
Virtusa
Posted: Dec 3, 2018
Last activity: Jan 2, 2019
Posted: 3 Dec 2018 16:28 EST
Last activity: 2 Jan 2019 10:59 EST
Closed

MSOGenerateExcelFile exports the excel with datetime fields as 20170921T180901.000 GMT

Hi All,

I'm using Pega 7.2.2 and I was using MSOGenerateExcelFile by creating a template and exporting the results of a report definition to excel sheet. The results are getting exported successfully but the fields with datetime gets exported as xxxxx GMT and not as 4/12/2018. Is there any better way of achieving this?

Cheers

***Moderator Edit-Vidyaranjan: Updated SR details***

To see attachments, please log in.
Reporting
Support Case Exists

Posted: 6 years ago
Posted: 2 Jan 2019 10:59 EST
Bhuvana Mahalingam (mahab_GCS) Senior Principal Engineer, Technical Support, User Experience
Pegasystems Inc.
US

Hi Satyakanth

Unfortunately, that is the expected behavior. 

Please check out these links

https://community.pega.com/support/support-articles/formatting-export-excel-using-binary-excel-file

https://community.pega.com/support/support-articles/numeric-props-exported-excel-grid-repeat-text-format

https://community.pega.com/support/support-articles/excel-data-does-not-generate-results-defined-property-mode

I have personally not experimented with macros, but, as discussed in these links, you can also attempt to try to use excel macro.

https://community.pega.com/support/support-articles/export-excel-functionalityusing-msogenerateexcelfile-activity

https://collaborate.pega.com/question/showing-numeric-values-excel-which-exported-using-msogenerateexcelfile-activity

 

To see attachments, please log in.

Related content:

Question

DateTime properties format converting GMT format in exported CSV

Discussion

Default PEGA DateTime Value 19700101T000000.000 GMT ?

Question

Field value is not working after export to excel

Question

Export To Excel is not recognizing the Date format, its showing as Text format for Datetime field

Question

OOTB Reports Export to Excel GMT Time Stamp Not Wanted

Question

pxGenerateExcelFile issue with the format of DateTime property on excel export

Question

DateTime format ignored when pzRDExportWrapper is used to export to excel

Question

Export a large number of records (100,000+) to excel from OOTB report browser

Question Solved

Report Definition is not showing till seconds in dateTime when exported to excel

Question

Export to Excel - Date and Time component of a DateTime property to be shown in 2 separate columns

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice