Summary: 

Dates shown are wrong while Exporting to XLSX

Symptoms: 

1. Login to CRM. Go to Preferences

2. Change Date/Time Preferences to mm/dd/yyyy

Description 

3. Go to Administration > Customization -> Communications > Fields

4. Change Date / Time to “Date Only” for comm_datetime

Description 

5. Do Metadata Refresh

6. Go to Reports > Communications

Description 

7. Run Report > Display to screen, Pdf, CSV, Excel CSV are working fine. It’s showing correct dates.

8. Now Export to XLSX

Description

- Dates shown are wrong

Description

Cause:

It happens only with 'Date Only' field. When we export the reports in XLSX format, it doesn't show the date only field correct.

More Information:

This issue occurs in 2017 R2 and will be fixed in 2017 R3.