In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

MRod
8 - Asteroid

Be sure to use the Input tool from the OUTPUT section to get the same results

 

Spoiler
markrod30_0-1589169107260.png

 

SideSweep7
7 - Meteor

Solved, but the original solution is more elegant. New function learned!

DMContente
8 - Asteroid

As mentioned, solutions will be slightly off as solutions and input values for Time_Now are different

mheinze
Alteryx Alumni (Retired)

One formula tool.

Spoiler
mheinze_0-1589928460308.png

 

ncrlelia
11 - Bolide

Challenge 10

VizChic
11 - Bolide

On a roll 🙂

AcevedoYo
8 - Asteroid

Today I learned what the Mod() function is. Thanks Community!

 

Also, took my a while to realize that the problem set is slightly off from the output timestamps. Was driving myself crazy

 

Spoiler
YomaraA_0-1590667100253.png

 

JenThomas
7 - Meteor

my solution

GBO95
Alteryx
Alteryx

My solution:

aatef
7 - Meteor

Solution to Challenge #10: Date Time Calculations