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 #10: Date Time Calculations

Tomasch
7 - Meteor

done

amanda_payne
8 - Asteroid

I added the seconds back before the rest

Spoiler
amanda_payne_1-1625684600414.png

 

Elias_Nordlinder
11 - Bolide

Here is my solution (2 solutions),

One long because I did  not get the first one to work first, and one shorter 🙂

 

Spoiler
Elias_Nordlinder_0-1626115419798.png

 

cwkoops
8 - Asteroid

My solution:

DanTh
Alteryx Alumni (Retired)
Spoiler
Fairly simple once I found the right Formula expression for Modulo.

5/5
KyronSmith
7 - Meteor

I found this one tricky, had to take a quick look at the solution... I better work on Formulas and RegEx's!

JoaoLeiteV
10 - Fireball

This was a quick one haha, just used a Formula to create and calculate the differences.

 

Spoiler
JoaoLeiteV_0-1626894557338.png

 

pdave87
11 - Bolide

Hi Alex,

 

That's very helpful and easy to understand. Thanks alot. 

 

Regards,

Pratik

pdave87
11 - Bolide

PFA my solution. There are multiple ways and they are quite simple. It's very good learning

rahulchetwani
5 - Atom

I have used the date calculation formula but in the first line of solution, mm/sec difference was 17 min 29 sec and mine is 16 min and 48 sec .Please let me know if you figured out my mistake.