Date issue when exporting Dynamic PivotTable

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

when exporting opportunities as Dynamic PivotTable in Dynamics CRM 2016 On-Premise the dates are exported in the US format (MM/DD/YYYY) but my excel perceives the dates as little-endian (DD/MM/YYYY).

This causes the issue that some dates are not seen as dates and others are wrong. Example:

30^th June 2016 is shown as 06/30/2016 = No date (would be 30th month of the year)
1^st March 2016 is shown has 03/01/2016 = Excel sees as 3^rd January 2016

I would think this is an excel issue, however, Dynamic Worksheet exports and Static Worksheet exports work perfectly fine!

Is there a way to solve this issue?

Thanks for any help,

Jonas

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Date issue when exporting Dynamic PivotTable

Hi Tycho,

Sadly I did not find a solution for this.

As a workaround I am currently using the Dynamic Worksheet export and as the table/range for the Pivot I use a formula-based dynamic range.

Best regards,

Jonas
Community Member Microsoft Employee on at

Like (0)

Report

RE: Date issue when exporting Dynamic PivotTable

Hi Jonas,

I am wondering if you have found a solution for this?

My customer is facing the same problem.

Kind regards,

Tycho