Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 13/3/2019
I got 3 whole number columns which I am mergin to create data column. But I am getting this wierd error. It cant covert some values to date type format. For example, 12 3 2019 was successfully ...
You are importing dates which are in a different format than your local settings e.g 13/4 or 4/13
Delete the step in Applied Steps.
Right click the column
Change Type -> Using Locale
...and pick the format of the country the dates come from
- Hi Anonymous,
Appear to me that you data is appering as Decemberandnot March dates that why when you are converting 13 3 2019 it givesan error since month 13doesnot exist.
One option is doing column by example.
Regards
Mfelix
This has been driving me crazy with some exported data - OMG, it exported some of the dates correctly and some were doing this and this fixed it - thank you thank you thank you!