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 currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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
14 - Magnetar
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