Coverting Text type to Date type data

[osibughe]

I can't seem to covert my data: text type format to date type format.

Please check images for error and any correction.original data1st : trying to change the format after dropdown format option didn't workresult from 1st try2nd tryresult from 2nd try3rd tryresult from 3rd try

[olgad · Accepted solution]

Your modelling language is probably English USA, since there the date format is MM/DD/YYYY it results in error, because there is no month 31. 
If you go to Using Local Option you can choose European standard DD/MM/YYYY then it functions well. 

Or under File-Options-Options and Properties-Regional Properties you can adjust the model language to reflect the language of your data.