DataFormat.Error: couldn't parse the input provided as a Date value

[Bensontsoi]

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? 

[Anonymous]

Sometimes the best answers are the simplest. Many thanks for this. 👍

[Bensontsoi]

@v-jingzhang 
Great thanks, it did help to solve my problem. 

[v-jingzhang · Accepted solution]

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!