Forum Discussion
Solved
DataFormat.Error: couldn't parse the input provided as a Date value
Hello everyone, I am converting the pdf into excel format when I am converting the data for September it shows up a data format error, could not identify the pdf month format"Sept" I...
Hi Bensontsoi
Before the "Changed Type" step, insert a step to replace "Sept" with "Sep". This will probably solve the problem.
Replace values and errors - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
Sometimes the best answers are the simplest. Many thanks for this. 👍