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

cmv
7 - Meteor
Spoiler
cmv_0-1591659702125.png

 

Skrupczak
7 - Meteor

My solution is longer because for some reason my brain thought part of it was having the workflow be able to translate the months for you (not writing out S=September, etc). I made this one harder for myself than it needed to be 

Spoiler
Challenge 21.PNG
cmv
7 - Meteor

I did pretty much the same as you but in a slightly compressed workflow by combining some of the steps. I still like it more than the many "ifs" on the months.

abowers004
7 - Meteor

I wanted to do this in a way to avoid a long formula, but in all honesty I need practice with expressions so I followed along with original solution. One thing I didn't get was why there were AND statements for months of Jan,Jun,Jul and Apr,Aug, but not for not May, only Mar. Seemed excessive and inconsistent.

CKP
10 - Fireball

My solution

 

Spoiler
challenge_21_mysolution.jpg
The_Rad_Valentina
8 - Asteroid

vradcha1_0-1592003763039.png

 

Used parse tool to get month into a different column. 

 

GeraldJTessier
8 - Asteroid

Here my solution

JKCecil
7 - Meteor

One of the few times I needed to peak at the solution to make it to the end.

Bernhardt03
7 - Meteor

My solution.

RNG
8 - Asteroid

.