Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
20 - Arcturus
20 - Arcturus

Nice one for a morning to start

Spoiler
challenge_258.PNG