File Change Date TTMMYYYY to YYYYMMTT

Dear Community,

in our project we have thousand's of files which are already named with TT.MM.YYYY_description.pdf
But now we see that this is not so using friendly cause windows shows the files now with Day first - example: first 01.02.2025 then 02.05.2025 then 10.02.2025 then 25.03.2025.

Our Decision was to change it to YYYY.MM.TT so the order will be 2025.02.01_letter, 2025.02.10_visit, 2025.03.25_notice, 2025.05.02_paper and so on.

But we are not happy about the fact that we have to name every file by hand - that are thousands. I've found Advanced Renamer and hope you can help me. Is there an script or function like that, that can rename Dates from one format to another format as batch? The Batch should only rename the first part of the file, the second part should be left untouched.

Thanks for help,
swarzkoe

Reply to #1:
Hi swarzkoe.

I think that you can use a regular expression and a Replace method for get what you want.
Try this:

REPLACE: (\d\d).(\d\d).(\d{4})
REPLACE WITH: $3.$2.$1
Use regular expression checked.

Miguel