Forum Discussion
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 have tried to change the locale but failed, the excel can read "Sep" but not "Sept"
Could anyone please take a look?
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!
3 Replies
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!v-jingzhang
Great thanks, it did help to solve my problem.
