Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / DataTime issue while i...
Microsoft Dynamics CRM (Archived)
Suggested answer

DataTime issue while importing data from datamigration tool in CRM

(0) ShareShare
ReportReport
Posted on by Yogendra 270

Hi,

I have created crm data with the help of DataMigration tool in crm and trying to import it in different server with same time zone(UK and dd/MM/yyyy).

Now issue is occurring with datetime field if date is 31/12/2018, tool storing it as null in CRM but if data is 12/12/2018(where day is within the range of month) it storing in CRM.

CRM system setting for datetime format and Logged in User option setting for datetime format is identical to target server's CRM.

*This post is locked for comments

  • Suggested answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at
    RE: DataTime issue while importing data from datamigration tool in CRM

    migrating Date/time format source data? Ensure this –

    1. If the date/time format of your source data differs from the one set by you in CRM settings ,then consider changing the CRM format settings accordingly before starting migration. It is advisable to take a small number of test records and verify your expectations before starting migration.

    2. Microsoft Dynamics CRM 4.0 Data Migration Manager validates the date data in your source data during migration. In cases where the date data is not in the format specified by your date format setting, DMM displays an error.

    3. DMM understands the date time settings of the user in whose context it is running. To change the user timezone in CRM go to ToolsàOptions and change your time zone. To change the date format settings go to ToolsàOptionsàFormatsàCustomizeàDate, change and save the settings. These settings will be used by DMM to migrate the dates and times.

    for more information refer this link: blogs.msdn.microsoft.com/.../data-migration-manager-tips-and-tricks

    Regards,

    Pranav.

    If found useful, please mark the answer as verified

  • Yogendra Profile Picture
    Yogendra 270 on at
    RE: DataTime issue while importing data from datamigration tool in CRM

    Hi Sandeep,

    Thanks for reply.

    I am using CRM 2015 and Date time Format is not available in CRM 2015.

    Issue is occurring with datetime field if date is 31/12/2018, Datamigration tool storing it as null in CRM but if data is 01/12/2018(where day is within the range of month) it storing in CRM and swapping it day & month (12/01/2018).

  • Suggested answer
    sandeepstw Profile Picture
    sandeepstw 4,601 on at
    RE: DataTime issue while importing data from datamigration tool in CRM

    Hi,

    Before importing data set date time field to target time zone after import you can change time zone. You can take help form this article.

    www.inogic.com/.../handling-datetime-fields-in-microsoft-dynamics-crm-update-1

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans