Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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
15 - Aurora
15 - Aurora

@PhilipMannering why do you think Kevin is younger?

LHolmes
9 - Comet

@OllieClarke 

@PhilipMannering 

 

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

PhilipMannering
16 - Nebula
16 - Nebula

@OllieClarke - because I had a brain-fart. 

@LHolmes  - you are correct, sir.

phottovy
13 - Pulsar
13 - Pulsar

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
abrouwer
8 - Asteroid

Solution attached

SWalker
7 - Meteor

Don't sleep on DateTime functions. 

dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1615241080610.png

 

rcarog
8 - Asteroid

Solution attached.

jacob_kahn
12 - Quasar

Great challenge! Love Date and Time!

 

the_jake_tool

#itsanalyticsyo

 

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

 

 

 

 

Qiu
21 - Polaris
21 - Polaris

Nice one for a morning to start

Spoiler
challenge_258.PNG