Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Data Discrepancy in Importing 'Date Only' field Value in Dynamics 365

Posted on by 3,155 Super User 2024 Season 1

Hi,

I recently come across data discrepancy in importing 'Date Only' field value to CRM using import wizard.

Environment: On-premise, Microsoft Dynamics 365 (8.2)

Field Details:

Entity: Custom, Field Name: Approved Date

 pastedimage1591694242046v1.png

I have exported few records of a custom entity from CRM and imported back after modifying Approved Date field value to '01/01/1900'. But, after successful import, Approved Date field value showed in CRM is one day earlier than what I imported. i,e 31/12/1899. The value stored in database and what I see in CRM are same. But, it is different when I export data to excel.

I have been changing this field to different values (using divide and conquer), and found one strange thing. This issue happens only for the date value between 01/01/1900 and 29/02/1900. Data imported with any date value on or after 01/03/21900 works perfectly.

Also faced the same problem when I tried new field 'Test Approved Date' with Behavior: Time-Zone independent. In below image, dates marked with red are the problematic ones, where as the green ones works perfect.

pastedimage1591695145894v2.png

Any help to address this issue is highly appreciated. Thanks

  • tattmardiff Profile Picture
    tattmardiff 25 on at
    RE: Data Discrepancy in Importing 'Date Only' field Value in Dynamics 365

    Has there been an update to this? I am experiencing the exact same issue with the native Birthday field on the contact entity.

  • zica Profile Picture
    zica on at
    RE: Data Discrepancy in Importing 'Date Only' field Value in Dynamics 365

    Please try to upgrade to V9.x and see if the issue is still there. If yes, please raise a support ticket to us for further investigation.

  • Chris4300 Profile Picture
    Chris4300 145 on at
    RE: Data Discrepancy in Importing 'Date Only' field Value in Dynamics 365

    Hello,

    Can you check if the same issue happens in 9.x versions as well?

    If no, then this could be a bug that was fixed. I would suggest that you raise a ticket with MS to check.

    Regards,

    Chris

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans