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 #58: An Odd String to Date Conversion

NISCHITHA-98
8 - Asteroid

solution

YuriTchong
7 - Meteor

Pretty easy after all these challenges.

emjiang
8 - Asteroid

regex - parse

Spoiler
emjiang_0-1638201926152.png

 

jon_amanrich
8 - Asteroid

Week 58 solution here!

Spoiler
jon_amanrich_0-1638289454286.png

Formula: New field called 'New-Date': if StartsWith([date], '0') then '19'+right([date], 6)
else '20'+right([date],6)
endif

Robinvm
8 - Asteroid

Solved

RobPearce
8 - Asteroid

A nice quick one!
Although admittedly, my solution isn't quite as elegant or robust as those in the solution 😛

DSinnett
Alteryx Alumni (Retired)

Just one formula, but fun to put together.

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 58.png

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 65.png

MariusNikiforovas
8 - Asteroid
Spoiler
MariusNikiforovas_0-1639257263012.png