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:
- Open the “Export_DateTime” HTML Property rule instance on your system.
- Perform a “Save As” of the HTML Property, specifying a new “Stream Name” and custom Ruleset and Ruleset version.
- Update the new HTML property to add the code below as illustrated in the example screenshot.
<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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.