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

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here258graphic.png

 

This week's challenge focuses on a group of relatives and their birthdays. Of the six family members, we have one person's date of birth and a series of clues to calculate the others. Provide the DOB for all family members and the day of the week s/he was born.

Aaron_Harter
11 - Bolide

Great start to the week with algebra & DateTime functions!

Spoiler
1.PNG
Luke_C
17 - Castor
Spoiler
Challenge258.PNG

Blake
12 - Quasar

Fun with the datetime functions!

 

Spoiler
258.1.png
Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1615215275654.png

 

PhilipMannering
16 - Nebula
16 - Nebula

My days until Friday calc.. not sure if it's correct..

Spoiler
7 - mod(tonumber(DateTimeformat([Date], '%u')) + 2, 7)

 

 

Spoiler
PhilipMannering_0-1615215599403.png

 

 

 

DeanWest
9 - Comet

Interesting word problem to practice some DateTime functions!

 

Spoiler
challenge_258_solution_DeanWest-snippet.png

 

 

jamielaird
14 - Magnetar

Voilà mon solution:

 

 

Spoiler
jamielaird_0-1615216730321.png

 

 

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
I used DateTimeAdd a lot...
patrick_digan_0-1615217155593.png

 

Spalders
8 - Asteroid
Spoiler
Spalders_0-1615217483881.png