community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

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!

Asteroid

 

 

Spoiler
Challenge 10 Pris.png
Highlighted
Asteroid

 

 

Spoiler
Challenge 10 Pris.png
Meteoroid

Solution attached.

 

Cheers

Meteor

Hello. Please see attached my solution! Thanks, Gavin

Asteroid

Hi! Here my solution :)

Asteroid

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

Challenge #10, done.

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

 

Spoiler
Challenge10.PNG

Cheers,