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.

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

@PhilipMannering why do you think Kevin is younger?

LHolmes
8 - Asteroid

@OllieClarke 

@PhilipMannering 

 

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

PhilipMannering
14 - Magnetar
14 - Magnetar

@OllieClarke - because I had a brain-fart. 

@LHolmes  - you are correct, sir.

phottovy
11 - Bolide

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.

the_jake_tool
12 - Quasar

Great challenge! Love Date and Time!

 

the_jake_tool

#itsanalyticsyo

 

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

 

 

 

 

Qiu
17 - Castor

Nice one for a morning to start

Spoiler
challenge_258.PNG