Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

Ladarthure
14 - Magnetar
14 - Magnetar

My solution!

Ziggy77
7 - Meteor
 
JoshuaM
8 - Asteroid

Easy enough! :)

bkclaw113
9 - Comet
 
erick_irigoyen
Alteryx Alumni (Retired)

I ended up using a combination of record ID, Tiles, and Formula.

 

Thanks, 

 

Erick

adityan92
7 - Meteor

Used tiling method to differentiate between the months! 

mbogusz
9 - Comet

Using Joins by Record Position and Text Input as logic.  This solution doesn't scale elegantly past 2 years of data though.

Challenge21Solution_mbogusz.png

 

cgoodman3
14 - Magnetar
14 - Magnetar

Here's my solution, needed to use a text input and join to get the months.

 

Spoiler
Challenge 21.PNG

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
RobertoEstrada
8 - Asteroid

Similar solution as the one posted.

RWvanLeeuwen
11 - Bolide

I wouldn't be all too happy if a customer would provide me a list formatted as such, but here's my take on the matter

 

Spoiler
21 - RWvL.png