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 #323: Analyze books Availabilities

Carolyn
12 - Quasar
12 - Quasar

Solved! Huge thank you to @PhilipMannering (3 years after he solved this problem) - I could not figure out why my Multi-Field Formula wasn't working right and felt like I was losing my mind. You solved yours the same way I did, which was to do a DateTimeAdd, and the trick was to wrap it in a ToDate(). I don't know if I would've gotten there on my own, so thank you!

 

Spoiler
2025-03-30 10_24_14-Alteryx Designer x64 - Challenge_323_Carolyn.yxmd.png

The Multi-Field Formula that was driving me crazy:
2025-03-30 10_24_27-Alteryx Designer x64 - Challenge_323_Carolyn.yxmd.png
JBevan89
8 - Asteroid

My Solution attached.

 

 

Spoiler
C323_JB.png

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-05-06 113358.png
Erin
11 - Bolide
Spoiler
323.png
RebekaMazuchova
8 - Asteroid

:)

Pilsner
13 - Pulsar

My solution:

Spoiler
323.png