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) / Data Import and Date +...
Microsoft Dynamics CRM (Archived)

Data Import and Date + Time

(0) ShareShare
ReportReport
Posted on by JDMCRM 1,799

Hi, 

I'm importing data into CRM, and I'm encountering a problem where imports are failing where there is a date and time field. 

Can you import the date and time a record was created from one system to another? 

Another thing I have noticed is that in the exported XML file from CRM the columns that are meant to be holding date and time data are filled with #######. Why is this? 

*This post is locked for comments

I have the same question (0)
  • Royal King Profile Picture
    Royal King 27,686 on at

    If you expand the column width in excel you will see the date properly. In order to import date time into crm make sure the import file has column type has datetime in case of date time field in crm.

  • JDMCRM Profile Picture
    JDMCRM 1,799 on at

    Thanks for the response, increasing the column width fixed the first issue. I don't quite understand the second half of the answer "In order to import date time into crm make sure the import file has column type has datetime in case of date time field in crm."

    Would it be possible to explain further?

  • JDMCRM Profile Picture
    JDMCRM 1,799 on at

    I Keep getting, "the date/time format is not valid, or the value is outside the supported range"

  • Royal King Profile Picture
    Royal King 27,686 on at

    in the source file make sure date time column type is set to date time.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Select the date/time column in Excel and then right click and choose "Format Cells" and choose one of the relevant category format i.e: Date and choose the format that relates to the date time format of the system, then save and try to import again

  • JDMCRM Profile Picture
    JDMCRM 1,799 on at

    Thanks guys, I'll see if that helps.

  • JDMCRM Profile Picture
    JDMCRM 1,799 on at

    That seems to have worked.

    One more question. How come if you export, for example, a price list and in the excel spreadsheet you have 'modified on' as a column, if you import it into a system that does not have a field for 'modified on' in the wizard and you choose to ignore it, it causes the import to fail. Even though you told it to ignore it?

  • Verified answer
    Royal King Profile Picture
    Royal King 27,686 on at

    Modified on is a system field and you can't update that field value. Even if you don't choose ignore system will automatically ignores this field value.

  • JDMCRM Profile Picture
    JDMCRM 1,799 on at

    Ah ok thank you.

  • JDMCRM Profile Picture
    JDMCRM 1,799 on at

    It turns out I have another problem.

    I have two isolated incidents of accounts failing to import because of the source data not being in the required format. The field is 'created on'. However, if I look at my excel spreadsheet the dates are in the correct format and are exactly the same format as the other 38 accounts that have imported successfully.

    i57.tinypic.com/2s0xzlc.png

    i57.tinypic.com/mt1hfn.png

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