Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #258: Relatively Old

OllieClarke
16 - Nebula
16 - Nebula
‎03-08-2021 09:38 AM

@PhilipMannering why do you think Kevin is younger?

Reply
LHolmes
9 - Comet
‎03-08-2021 09:46 AM

@OllieClarke 

@PhilipMannering 

 

I'm going to guess it has to do with DateTimeAdd subtraction syntax appearances.

Reply
PhilipMannering
16 - Nebula
16 - Nebula
‎03-08-2021 10:05 AM

@OllieClarke - because I had a brain-fart. 

@LHolmes  - you are correct, sir.

Reply
phottovy
13 - Pulsar
13 - Pulsar
‎03-08-2021 10:06 AM

Instead of individual formulas, I decided to go with an iterative macro that lets you set up all the formulas at the beginning:

Spoiler
Workflow:
258.PNG

Macro:
258_Macro.PNG

Formulas Table:
258_Formulas_Table.PNG
challenge_258_ph_solution.yxzp
Reply
abrouwer
8 - Asteroid
‎03-08-2021 12:00 PM

Solution attached

challenge_258_solution_file - AJB.yxmd
Reply
0 Likes
SWalker
7 - Meteor
‎03-08-2021 01:57 PM

Don't sleep on DateTime functions. 

SWalker_Challenge_258_Solution.yxmd
Reply
0 Likes
dsmdavid
11 - Bolide
‎03-08-2021 02:04 PM
Spoiler
dsmdavid_0-1615241080610.png

 

david_258.yxmd
Reply
0 Likes
rcarog
8 - Asteroid
‎03-08-2021 02:10 PM

Solution attached.

challenge_258_solution.yxmd
Reply
0 Likes
jacob_kahn
12 - Quasar
‎03-08-2021 02:22 PM

Great challenge! Love Date and Time!

 

the_jake_tool

#itsanalyticsyo

 

https://www.linkedin.com/in/jacob-kahn-/

 

 

 

 

challenge_258_jk.yxmd
Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎03-08-2021 02:57 PM

Nice one for a morning to start

Spoiler
challenge_258.PNG
challenge_258_start_file-Qiu.yxmd
Reply
0 Likes
Live Weekly Challenge