We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
RegEx! It's your friend!
For this one I used a Formula tool with a bunch of formula in series:
IF Left([date],1) = "1" THEN 20
I then used a RegEx to slice out the yyyy,mm,dd:
and then another Formula tool to rehypothecate (!!!) the string
and finally a Select tool to tidy up.