Want to get involved? We're always looking for ideas and content for Weekly Challenges.
I like to use weekly challenges to fill short gaps in trainings. This one is great for prep and blend training because we get to really explore the concept of character positions in a word and dive into the complexities of date time formatting.
Single formula approach, Bazinga!!!!
IF left([date],1)='0' THENToDate( '19'+Substring([date],1,2) +'-'+ Substring([date],3,2)+'-'+Substring([date],5,2))ELSEToDate('20'+Substring([date],1,2) +'-'+ Substring([date],3,2)+'-'+Substring([date],5,2))ENDIF
Here's my solution.