Challenge #46: Formatting a Date from an Integer

[celinednguyen]

Please see attached!

[chloeanggg]

Here is my solution.

[Justin_Bell]

Well, I got to go down a fun RegEx Rabbit Hole for this one. To be fair I never actually converted into DateTime format, but then again the challenge said we were working with an integer that was a word, so I worked with a word.

I used RegEx to define all 7 characters of the string in 4 groups - the decade ID/year/mm/dd, then replace the decade ID $1 with 19 or 20, and then format the rest at the same time with dashes to just do it all in one tool. Formula runs .3ms (6.8% of the total runtime)

Enjoy

[jpg34]

Spoiler

Spoiler

 

[DhritiBhakat]

Done!

[msobyjr]

solution

[meesz]

They better recognize

[ystossel1]

Useful to know

[ChristopherCamper]

Attached