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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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

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
13 - Pulsar
Spoiler
Challenge258.PNG

Blake
12 - Quasar

Fun with the datetime functions!

 

Spoiler
258.1.png
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1615215275654.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar

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
16 - Nebula
16 - Nebula
Spoiler
I used DateTimeAdd a lot...
patrick_digan_0-1615217155593.png

 

Spalders
8 - Asteroid
Spoiler
Spalders_0-1615217483881.png