Forum Discussion
Coverting Text type to Date type data
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
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.
1 Reply
- olgad
Resident Rockstar
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.