alteryx Community

# 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.

## Challenge #258: Relatively Old

Alteryx

A solution to last week's challenge can be found here

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.

11 - Bolide

Great start to the week with algebra & DateTime functions!

Spoiler
17 - Castor
Spoiler

12 - Quasar

Fun with the datetime functions!

Spoiler
16 - Nebula
Spoiler

16 - Nebula

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

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

Spoiler

9 - Comet

Interesting word problem to practice some DateTime functions!

Spoiler

14 - Magnetar

Voilà mon solution:

Spoiler

17 - Castor
Spoiler