Changing Date Format

[rja541]

I have a document system which has a date format which I need to change

The documents currently read: DD.MM.YY - Document Name

e.g. 13.01.23 - Notice of Transfer

What I need is to convert the DD.MM.YY format to YYYY.MM.DD

e.g. 2023.01.13 - Notice of Transfer

Can anyone help?

Thanks in advance.

[Luuk]

With RegEx(1) the "Match" and "Replace" can be something ike...
^(\d\d)(\.\d\d\.)(\d\d)( - .+)
20\3\2\1\4

13.01.23 - Notice of Transfer -----> 2023.01.13 - Notice of Transfer