Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

jackgmoroney
Meteoroid
Spoiler
jackgmoroney_1-1687072694131.png

 

Spurs
Asteroid
Spoiler
Spurs_0-1687190457575.png

 

bwins
Asteroid

Won't let me provide a screenshot

Denis_Ryan
Meteor

solution

mithily
Asteroid

This was fun using date specifiers as needed

my solution

Adrien_Sourdille
Asteroid
Spoiler
Alt 258.png
CVCurcurato
Asteroid

Horrified by how long my solution is in comparison to others :(

dj-khaled-another-one.gif

AmanDevrath
Meteor

for Juliette's date : I used 

 

DateTimeAdd([Stephane],5-toNumber(DateTimeFormat([Stephane],"%w")),"days")

 

%w returns day number. 0-sunday, 1-monday, 2-tuesday, 3-wednesday, 4-thursday, 5-friday, 6-saturday.

I subtracted 5 from the returned day number (in this case 5-2), which gave me 3 days from the stephane's birth date for juliette.

CBarito
Asteroid

🙂