When exporting to Excel date format is in YYYYMMDD
When attempting to export a date field to Excel, output is expected to be in the format 'MM/DD/YYYY'. Instead the content is presented in the format 'YYYYMMDD'
Steps to Reproduce
- Upload a file to the webwb folder
- Use the MSOGenerateExcelFile control and pass the file as a parameter
A third-party product issue. Excel reads the HTML stream produced by the activity using specific formatting.
Please view the following PDN article on altering the HTML stream format: https://pdn.pega.com/support-articles/on-export-to-excel-date-format-inconsistently-as-mm-dd-yyyy
(In the below div tag the style must be the format which we want to export to excel.)
<div class="excel-date" style="vnd.ms-excel.numberformat:@">
0% found this useful