Challenge #414: Mastering Date Formats

[fesrimo]

The Weekly Challenge are very intereting, I was solving multiple of them.

My solutions for challenge Weekly #414

[JosephSerpis]

Challenge Completed

Spoiler

[CASaiRam]

This was a good one to learn some new techniques with date time parsing, regex and different formulas. It was challenging

[CASaiRam]

This was a nice challenge to explore datetime parse formulas. Your approach has enabled me to explore the date time parse concepts. Thanks.

[brette]

so many ways to do this but given small scope gone with the quick and easy but maybe not the most elegant

[ScottLewis]

If we're going to do this with formulas, we can do better than writing a Contains for every case. The second half of the string is pattern for the first half, so we can find each subfield in the second half and shift the index into the first half to read the value. Although that isn't date format practice so much as substring practice. Still, it works as long as the input matches the pattern of 10 chars data,10 chars pattern.

Workflow is the same one formula and a sort as several other responses, but the formula is 

Spoiler

substring([Date Field],FindString([Date Field], "yyyy")-11,4)
+"-"+
substring([Date Field],FindString([Date Field], "mm")-11,2)
+"-"+
substring([Date Field],FindString([Date Field], "dd")-11,2)

[MaxWilliamsBoko]

Solution attached

[a-gonzalez]

Spoiler

[Towers]

classing this as a one tool solution 🤣

Spoiler

 

[CammyPhillips]

:)