Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #21: Date Reformatting

lyon_abido
8 - Asteroid
Spoiler
Screenshot (83).png

A bit of a brute force strategy I think, but I got it. Fun challenge! 

jerviss53
8 - Asteroid

Solution Attached

CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1677464861071.png
dougbaron
8 - Asteroid
Spoiler
dougbaron_1-1677686066165.png

 

carol2021
8 - Asteroid

Solution

Archie_bos
8 - Asteroid

here is my solution

katestrohm
6 - Meteoroid

katestrohm_0-1678815041157.png

1. Formula 1: Left([Date], 1)

    Formula 2: IF Length([Date]) >2 THEN Right([Date], 2) ELSE "" ENDIF

2. Multi-Row Formula for the Year column: IF IsEmpty([Year]) THEN [Row-1:Year] ELSE [Year] ENDIF

3. Multi-Row Formula to create a month number/count column: [Row-1:Month number]+1

4. Switch function to replace numbers with month abbr: Switch([Month number],Null(),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6,'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec')

5. Select tool to hide a month number/ count column

Spurs
8 - Asteroid
Spoiler
Spurs_0-1678878746617.png

 

nbendoff
7 - Meteor

solution

bhrmitra
10 - Fireball

Solution Attached !!