Challenge #46: Formatting a Date from an Integer

[KristineWiesner]

my submission for challenge #46

[vakachiranjeevi]

My solution - 2 Approaches

[RodVillareal]

My first weekly challenge!

[Matthew]

Solution

[emily_cummings]

solution:

[dkungu]

solution

[Raees09]

My solution

[ebostwick]

I recently learned that I could use REGEX in formulas (yes, I'm still new at this 🙂), and this challenge was a GREAT opportunity to implement that knowledge!

Spoiler

 

[ebostwick]

I tried a suggested solution: DateTimeParse(switch(Left([date],1),'','0','19','1','20')+Right([date],6),'%Y%m%d'); but since the string length is set to "7," the 8th character gets truncated when "19" or "20" are added to the left of the[date] string.  However, if the result is created in a [New Date] column, the string length of the new column be changed to "10" in the Formula tool. 👍

[anna_vi]

Done!