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