Format Cells and extraction

[Maxime_LAUGIER]

Hello Everyone,

I need your help today because i would like to extract in a specific range all datas with the year 2023.
During my extract, i use the activity format cells with jj/mm/aaaa (because it’s in french)

The column from T0 to toXXX has changed correctly, but I can’t add a filter that only includes the year 2024, only to delete it afterwards and have only 2023 data.

Any ideas?

Thanks

[jinal.shah (Jinal Shah (Mr.Techie))]

Adjust the date format in the regular expression ((?<=(\/|\-)|\b)\d{4}(?=\/|\-|\b) ) to match your specific data format (e.g., -?\d{4}-? for YYYY- format)

[Maxime_LAUGIER]

Thank you for your reply,

Do you mean i have to use a matches activities?