Hi, My CRM instance is on dd-mm-yyyy format, now i want to upload a records which has a date field column. I'm keeping my dates column to dd-mm-yyyy format and importing the records but after importing the dates format changes to mm-dd-yyyy format and i'm not able to fix this.
Can anyone help on this?
NOTE:- My local machine is also on dd-mm-yyyy.
Thanks
*This post is locked for comments
Hello ,
Just make sure that System setting AND personal options are on the same format (dd/mm/yy)
after that make your excel data as a table and try to filter by your date ,just to check that all dates are correct and following the same format dd/mm/yy
finally , if it didn't work for you , just change the date in your excel to mm/dd/yy
Yes it is also in dd-mm-yyyy format.
Hi,
is you Excel also in dd-mm-yyyy format?
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (