Microsoft Dynamics CRM

{Issue Resolution}The date/time format is not valid, or the value is outside the supported range in Dynamics CRM data import

Recently I have been involved in analysing data migration analysis from a third party CRM system into our great product – Dynamics CRM.

Let me add a quick one liner for a good practice as well!

I really appreciate the efforts from the client as they understood the need of doing a Data migration analysis, as in such projects that is one of the main pillars for Success of the project.

image

Well, coming back to the issue at hand here. Client wanted to import Created on Date as well for historical references. CRM import wizard started throwing following weird error on the imports:

The date/time format is not valid, or the value is outside the supported range

Issue resolution is quite simple:

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

Please note: Correct format is very important, so be careful English(UK) is different from English(US) for instance.

Hope it helps and Happy CRMing as usual!

If you liked the post, Please leave feedback – it is important to keep writing content that you really need!

Do share in your networks, LinkedIn, Twitter or Facebook!

Advertisements

2 thoughts on “{Issue Resolution}The date/time format is not valid, or the value is outside the supported range in Dynamics CRM data import”

  1. Hi Deepesh, thank you for this information. I’ve tried to import data into a Spanish organization and the import keeps failing regardless the date time format I choose.
    I’ve tried your tip but the system keeps complaining about the format (I’ve used dd/MM/yyyy which is Spanish format, but the error message shows a datevalue in MM/dd/yyyy).
    The only way it works is by exporting the file to .csv, which nowadays is my preferred import data format).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s