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
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
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