web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Suggested answer
    sandeepstw Profile Picture
    sandeepstw 4,601 on at

    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

  • Yogendra Profile Picture
    Yogendra 270 on at

    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
    PranavShroti Profile Picture
    PranavShroti 4,510 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans