How to change date format from from MM/DD/YY to DD/MM/YYYY

Yusuf Qureshi

I have a data in which I have a dates mentioned in MM/DD/YY which I want to convert it to DD/MM/YYYY, is there a easy way to convert the same.

gerdb42

The basic approach would be a simple RegEx Search&Replace:

Search for: (\d{2})/(\d{2})/(\d{2,4})
Replace with: \2/\1/\3

Of course this is only a simple rearrangement of digits.

gerdb42

Ok, edits only allowed for 180 seconds, so I have to use a reply to self.

Overlooked the conversion from “YY” to “YYYY”.

search for : \d{2}/\d{2}/\d{2}
replace with: \2/\1/20\3

Works only for Dates in the 2000s, of course.

guy038

Hello Yusuf and Gerdb42,

Gerdb42, I think that, annoyed about waiting 3 minutes to correct your post, your just omit the 3 groups to re-arrange the date :-))

So, Yusuf, the correct Gerdb42 S/R is, of course :

SEARCH : (\d{2})/(\d{2})/(\d{2})

REPLACE : \2/\1/20\3

Cheers,

guy038

P.S. :

Oh ! Thinking about the 2000’s years, here is an other solution :

SEARCH : (\d{2})/(\d{2})/(([0-4])\d|[5-9]\d)

REPLACE : \2/\1/(?{4}20:19)\3

So, supposing the year, written with TWO digits :

If the year is between the 00 and 49 values, we rewrite the string 20, followed by the year value
If the year is between the 50 and 99 values, we rewrite the string 19, followed by the year value

For instance, the two dates :

12/15/49
01/15/50

would be changed into :

15/12/2049
15/01/1950