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

Notifications

Announcements

No record found.

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

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…

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