Forum Discussion
Solved
How to deal with errors on dates?
Hi all, This date is in the format dd/mm/yyyy How is it that it ends up with errrors when switching the data type from 'text' to 'date' ? How to fix it? thx for helping!
adrien5555 Your Locale Setting must not be US - while your data source is set up to the US date format.
Look at the picture - I changed my default to UK and got the same error as you!
so you should probably split by delimiter and then re-assemble in the order DD/MM/YYYY
I could be wrong, but that looks like you're translating from mm/dd/yyyy instead of dd/mm/yyyy to me.