Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Time Discrepancy after Exporting from Report Wizard in CRM 2011

(0) ShareShare
ReportReport
Posted on by 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

  • Charan Raju C R Profile Picture
    Charan Raju C R 7 Super User 2024 Season 1 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans