Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Facing issues in summary view and report definition

SA-5165

Summary



In summary view drill down time format is changed from 12hr to 24hr format after exporting to excel/pdf


Root Cause



The issue seems to be being caused by Excel.
Refer http://excelsemipro.com/2011/06/regional-date-formats-in-excel/ for more details


Resolution



This issue is resolved through the following local change:

 
  1. Open the “Export_DateTime” HTML Property rule instance on your system.
  2. Perform a “Save As” of the HTML Property, specifying a new “Stream Name” and custom Ruleset and Ruleset version.
  3. Update the new HTML property to add the code below as illustrated in the example screenshot.
(In the below div tag the style must be the format which we want to export to excel.)
 
<div class="excel-datetime" style="vnd.ms-excel.numberformat:mm/dd/yyyy hh:mm am/pm">
 
{existing code}
</div>
     4. 
Open the Detailed view rule you wish to update and add the new custom html property in the column Export Format Values for the corresponding date time property field.
     5. Save the rules, execute the summary view and perform drill down and Export to Excel.

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

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

Pega Community 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
Contact us