Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution
After my solution, when I checked the solution attached by the author
I noticed they have used just one tool to derive the solution
By minimizing the tools, we can built a workflow which will not look complex where one tool is used to make one function.
Solution file learning
if Left([date],1 == "0" then DatetimeParse("19"+Right(date],6, "%Y%m%d)
else DatetimeParse("20"+Right(date],6, "%Y%m%d)
endif