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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Change type of date while loading

(0) ShareShare
ReportReport
Posted on by

Hi Experts!!!

I am having problems with loading data.

I have created a test entity with three fields of date. Each one for each type of date, local user, Only date and Independent  hour zone.

Then I download the load template and fill with all of type of date. 

When I upload this record, the system change the format date from DD/MM/YYYY to MM/DD/YYYY. And consequently, the process load fails.

Example 

Date Origin 29/09/2015

The data isn't neccesary format 09/29/2015 (in Spain format, it will be day 9 month 29 year2015)

I check CRM is in Spain time Zone, and the Excel ,I used, too.

I have checked to use the .CSV method and it works. But this method is more complex to end users (according their opinion)

Thanks in advanced!

*This post is locked for comments

I have the same question (0)
  • Mahendar Pal Profile Picture
    45,095 on at

    Did you check if your time zone setting is correct, it will pick time zone of the importing user.

  • JMdeSingular Profile Picture
    on at

    Yes I have checked the time zone in CRM and Excel I use for loading data

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans