cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | We’re thrilled to announce our newest Alteryx Designer Expert Certified users! Learn more.
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #21: Date Reformatting

Meteoroid
Spoiler
Spoiler

with a little added bonus

Alteryx Partner
Spoiler
21.PNG
Bolide

What a breath of fresh air after the incredible parsing in challenge #20

Meteor

Getting easier.

Asteroid

Used my own input file for the challenge

Alteryx Partner

I did a lot of manual encoding first, then followed the number to month approach

Comet

One more down

Asteroid

and another.

Bolide
Bolide

Some of the past exercises help prepare for this one.  Finished fairly quickly!

Highlighted
Meteor

Challenge #21 solved.  I had slightly different logic to produce the years and the months.  I used LENGTH to find the starting points for each year.