Dates shown are wrong while Exporting to XLSX
1. Login to CRM. Go to Preferences
2. Change Date/Time Preferences to mm/dd/yyyy
3. Go to Administration > Customization -> Communications > Fields
4. Change Date / Time to “Date Only” for comm_datetime
5. Do Metadata Refresh
6. Go to Reports > Communications
7. Run Report > Display to screen, Pdf, CSV, Excel CSV are working fine. It’s showing correct dates.
8. Now Export to XLSX
- Dates shown are wrong
It happens only with 'Date Only' field. When we export the reports in XLSX format, it doesn't show the date only field correct.
This issue occurs in 2017 R2 and will be fixed in 2017 R3.