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 !!