Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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 #4: Date Parsing

aly33
5 - Atom

Here is my solution

gawa
16 - Nebula
16 - Nebula

As cannot edit last post, upload solution as a new post

olivier_newman
8 - Asteroid

Not sure I've done this the most effective way but got there eventually 

perin
8 - Asteroid

A few steps and the magic is done!image.png

TheOC
15 - Aurora
15 - Aurora

A spicy Regex challenge


Bulien
InchulKo
7 - Meteor

Here is my solution!

EnglishmaninNY
8 - Asteroid

I used a similar initial approach but separate out each regex output in a separate tool. I was also a little more catch all. Anyway review the solution certain brought up my knowledge of regex up a notch.

 

Not sure I understood the need to parse out the different date components. I just put in a formula and DateTimeParsed with a if statement to change the parameter appropriate for each category.

 

Spoiler
Screenshot 2023-09-15 153106.png
orangebomber
7 - Meteor

spoiler

aangsg
7 - Meteor
Spoiler
Ch4.PNG

wow this was hard!

williamnolan03
8 - Asteroid

This one was fun to stretch my brain on!