360
When importing any excel file into Dynamics 365 including csv and txt delimited tabs I get the error saying the date is in an invalid format. I tried clicking on Export to excel and open with excel online and when it does and I key in a new record and insert the date (type it out) then click Save to dynamics it returns the same error.
Any suggestions?
*This post is locked for comments
This was done by going to the Settings top right then options then Formats..
The system settings had English US settings but personal settings had other format. So the system pulls the data in US format and when the record is created it throws an error because system doesn't match personal.
Upon changing personal date settings format to US the import was ok.
If it says the date in not in correct format, that means it is not. Check the date format of CRM from options (top right corner). Convert the date column to have same format and then upload.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (