community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #10: Date Time Calculations

Asteroid

Here is my solution

Asteroid

My solution

Asteroid

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

Alteryx Partner

 

 

Spoiler
Challenge 10 Pris.png
Highlighted
Alteryx Partner

 

 

Spoiler
Challenge 10 Pris.png
Alteryx Partner

Solution attached.

 

Cheers

Meteor

Hello. Please see attached my solution! Thanks, Gavin

Asteroid

Hi! Here my solution :)

Alteryx Partner

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.

Alteryx Certified Partner
Alteryx Certified Partner

Challenge #10, done.

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

 

Spoiler
Challenge10.PNG

Cheers,