ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

KKSzpakowski
8 - Asteroid

Thanks for the challenge! I have completed it.

 

 

Spoiler
Tools used: Formula, DateTime and Select.

Formula used to separate leading "1" and "0" from date string ("Sep1" and "Date 2"), to determine a start of full year ("19" for "0" or "20" for "1") and to combine "Start of Year" with Date 2" into "Correct Date".

date                    Sep1          Date 2            Start of Year          Correct Date
1040202             1                 0400202         20                         20040202

DateTime to convert the "Correct Date" to a data field.
Select ... to select only the needed ones :).

 

 

olga_strubbe
11 - Bolide

A neat challenge with parse challenge for string conversion to date format.  It was neat to be able to do it in a single formula.

Thank you.  

Borja_Leiva_Pla
5 - Atom

My solution

StanleyKinnok_Chan
8 - Asteroid

Here is my solution

DanielG
12 - Quasar

This is the exact same challenge as week 46, but here is my solution anyways.  (I have been blasting through the basic challenges, that is why I noticed the duplication)

Majd99
7 - Meteor

Pretty Simple

ydevis
8 - Asteroid
Spoiler
ydevis_0-1671021592228.png

 

lucascs
8 - Asteroid

solved, same as 46

KwintenDV
8 - Asteroid

Solution in attachment.

es7h3r
7 - Meteor
Spoiler
challenge 58.png

 

Same as Weekly Challenge #46