Date Error

[Anonymous]

In my file, I have the date specified in MM-DD-YYYY Format, when I transform the dates to date format few rows displays as Error. I'm not sure how to change the MM-DD-YYYY format to DD-MM-YYYY. Any help would be appreciated. Thanks 

[Anonymous · Accepted solution]

right-click on the column headder > click change type > Click using Locale > Select date then US

I would ❤ Kudos if my solution helped.