This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
community Data Science Portal Alteryx.com
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

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #258: Relatively Old

OllieClarke
13 - Pulsar
13 - Pulsar
‎03-08-2021 09:38 AM

@PhilipMannering why do you think Kevin is younger?

Reply
LHolmes
8 - Asteroid
‎03-08-2021 09:46 AM

@OllieClarke 

@PhilipMannering 

 

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

Reply
PhilipMannering
14 - Magnetar
14 - Magnetar
‎03-08-2021 10:05 AM

@OllieClarke - because I had a brain-fart. 

@LHolmes  - you are correct, sir.

Reply
phottovy
11 - Bolide
‎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
the_jake_tool
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
17 - Castor
‎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