Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution.
I used left((if Substring([date],0,1)='0' then '19' else '20' endif)+ToString(Substring([date],1,length([date]))),4)+"-"+Substring([date],3,2)+"-"+Substring([date],5,2) to get the results.
But interested in understanding the efficiency of using Left/right vs. Substring;switch vs. if..else.
Attached is my solution using formula, date/time parse tool and select... the solution is much slicker. I've never used a datetimeparse tool before...I'll have to remember that.