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 #414: Mastering Date Formats

AronasZilys
8 - Asteroid

Screenshot 2025-05-23 154733.png

martinson
11 - Bolide

Loves dates

Cheers,
martinson

LinkedIN

Bulien
BS_THE_ANALYST
15 - Aurora
15 - Aurora

Two solution routes. Learned the ifelse contains date parsing trick from marqueecrew on an oooooold challenge. Revamped this with a regex_countmatches here, love this as a identity tool.

 

also tried doing it without using datetimeparse! Was a fun route.

Spoiler
Time Taken 11:45
Screenshot 2025-06-01 220208.png

All the best,
BS

LinkedIN

Bulien
Ishan_Choubey
7 - Meteor

Done !!!

Pilsner
12 - Quasar

My solution:

Spoiler
414.png