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

Anastasiia
Asteroide

Here is my solution

nini
Asteroide

My solution

HuwHallam
Asteroide

I got it out, but entirely using cumbersome formulas... I'm sure the solution will be much neater - looking forward to checking it!

prislam
Asteroide

 

 

Spoiler
Challenge 10 Pris.png
prislam
Asteroide

 

 

Spoiler
Challenge 10 Pris.png
Strohy
Asteroide

Solution attached.

 

Cheers

gcarroll
Meteoro

Hello. Please see attached my solution! Thanks, Gavin

RichoBsJ
Bólido

Hi! Here my solution :)

rfergus
Asteroide

Calculations are longer than they could have been with some other methods but it works. It's nice to see how others do it to learn some of their tricks. I think I may add some to my workflow as a reference.

Thableaus
17 - Castor
17 - Castor

Challenge #10, done.

First thought of using Floor function, but I remembered that Mod function works a bit better.

 

Spoiler
Challenge10.PNG

Cheers,