Forum Discussion
Post PatronWe couldn't parse the input provided as a DateTime value..
OLE DB or ODBC error: [DataFormat.Error] We couldn't parse the input provided as a DateTime value..
My data source is SAP BW
My date column is in text and when i convert it to date it gives me the above error.
I tried splitting and then merging back the column but didn't seem to work out.
Thanks.
Nimai123 , refer is these can help
Check the exact error on power query
handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTsYou should be able to convert text formatted date's to dateTime without any issue so there is something trong with the text. It might be that it's the wrong delimiters or that there are other blankspaces present in the date. If you provide an image of the dates I might be able to see if there are any issues directly.
Otherwise what you can do if you really can't get it to work is splitting the text column up in year, month and date and use this custom column to create a date: (Make sure that all three columns are formatted to whole number)#date([Year],[Month],[Date]) as date
Br,
J
7 Replies
- amitchandak
Super User
Nimai123 , refer is these can help
Check the exact error on power query
handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs- Nimai123
Hello amitchandak
Thanks for the informative links.
In my scenario, I cannot replace the error values as I need the rows as the sales data with date and I also tried changing the Locale which also didn't help!
Are there any other options I can try!
Thanks!
- tex628
Community Champion
You should be able to convert text formatted date's to dateTime without any issue so there is something trong with the text. It might be that it's the wrong delimiters or that there are other blankspaces present in the date. If you provide an image of the dates I might be able to see if there are any issues directly.
Otherwise what you can do if you really can't get it to work is splitting the text column up in year, month and date and use this custom column to create a date: (Make sure that all three columns are formatted to whole number)#date([Year],[Month],[Date]) as date
Br,
J
