News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... CRM 2013 Update Rollup...

Customer experience | Sales, Customer Insights,...

Unanswered

CRM 2013 Update Rollup 5 - Data Import Date Error

(0) Share

Report

Report

Posted on by mazma

10

Since updating to Update Rollup 5 for Microsoft Dynamics CRM 2013 Service Pack 1 we have had an issue with importing dates via the data import where the dates in the import files are dd/MM/yyyy but it is now expecting dates to be in MM/dd/yyyy.

Fields are Date Only fields, users doing the import have personal options set to English (United Kingdom). I notice in the "issues taht are resolved section", this issue has listed as being resolved

Date format is changed from DD/MM/YYY to MM/DD/YYYY after new records are imported.

Any ideas on how to resolve?

All responses Img

All responses (2)

Answers Img

Answers (0)

mazma 10 on at

Like (0)

Report

RE: CRM 2013 Update Rollup 5 - Data Import Date Error

This is by CSV, oddly xlsx works fine.

Unfortunately we have lots of automated imports from external parties that are CSV.
edmunch on at

Like (0)

Report

RE: CRM 2013 Update Rollup 5 - Data Import Date Error

Are you importing as CSV or XLSX?

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

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

#2

Martin Dráb 230,492 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans