News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Time Discrepancy after...

Microsoft Dynamics CRM (Archived)

Time Discrepancy after Exporting from Report Wizard in CRM 2011

(0) Share

Report

Report

Posted on by Charan Raju C R

7 Super User 2024 Season 1

Hi,

We are facing an issue in 'Export to Excel' function in Report Wizard. We have created one simple report using OOB Report Wizard(not SSRS), which contains few DateTime fields like CreatedOn. The DateTime values showing in CRM & Report Viewer is with respect to logged-in user's timezone(UTC+8) as expected. But after exporting report to excel, it is showing the time with 8 Hrs delay(UTC). We are expecting these DateTime values to be same as in CRM even after exporting it to excel.

Is this a bug from CRM? Can anyone help to fix this issue, please?

Thanks,

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Charan Raju C R 7 Super User 2024 Season 1 on at

Like (0)

Report

RE: Time Discrepancy after Exporting from Report Wizard in CRM 2011

Thanks for your reply. I tried by converting cell to text, still showing the incorrect Date&Time. One of the CRM 2011 org with UR8 doesn't have this issue. But it is there in an org with UR18. Seems this issue got introduced in the versions after UR8.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Time Discrepancy after Exporting from Report Wizard in CRM 2011

Looks like a bug. Can you please convert the cell to text and see.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans