Challenge #46: Formatting a Date from an Integer

[MarMu]

Pretty straight forward solution to this weeks challenge.

Spoiler

[JoBen]

Cheers! I work with dates in this format everyday. Very practical application. 

[ksheerasagarm]

Here is the Solution for Challenge 46

[Aidan_K]

Here is my solution, I would say there is a lot of ways to complete this one....

thanks,

A.

[pasccout]

Here is my solution

[Ruud]

I have an unhealthy and unfounded hatred towards the DateTime tool.

[zm1]

Spoiler

 I noticed a pattern in the data that strings that started with "1" were for the year 2000 onward. RegEx made it so that I had the first digit parsed out and the remaining six digits in another field. Then, if the result from my first parsed group was "1," I added "20" to the front of the second parsed group (and "19" otherwise). Then used the DateTime tool to convert the string to a DateTime field and Select tool to truncate it to a Date field. Voila.