Not grabbing french date when month is "juin"

Hello,

I want to process my electricity bills but am running into an issue.

I'm using the following to grab the date from the document: " du ,31, ,December, ,1999".

It was working great but unfortunately it is skipping dates that have the month June (juin). When I preview the rule, I see that the text does contain what should be registered as a date ( du 1 juin 2017).

Any help would be appreciated!

Are you using the automatic date detection? Have you tried specifying the format manually?

Also, are those commas supposed to be there?

Here is the date format that I'm using: https://d.pr/lEQtSx. The commas showed up when I copied and pasted the text from the field into my post.

Here is the first date in the document that it is not picking up: https://d.pr/SjFPNi. The date that hazel is picking up is further down in the document and can be seen here: https://d.pr/8NT9Iv.

Thanks!

Edit: here it is with the 2017 document: https://d.pr/OLMkJj

In your pattern, you are selecting the date with both digits underlined. That means you are expecting a two digit date. It won't pick up that first date since the day is a single digit ("4" vs "04"). Try changing that in your pattern.

Ahh! That makes a lot more sense. Thanks for the help!