Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 13/3/2019
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
It looks like Power Query is using mm/dd/yyyy to convert the dates. So it is treating 12/3 as Dec 3, not Mar 12. Therefore you get this error as there is no 13th month.
How are you merging these together are you trying to build a string, then convert it to date?
If you want to use a string it's usually best to use the yyyy-mm-dd format as it is unambiguous or you could pass a specific culture parameter to Date.FromText to specify how the date format should be interpreted.
Or you could use the #date function which you can call using #date( <yyyy>, <m> ,<d>) , so in your case you could just pass in your 3 numeric columns directly