Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #206: Hotel Reservations

Highlighted
6 - Meteoroid
Spoiler
nmacpherson_0-1583783375047.png

 

Highlighted
8 - Asteroid
Spoiler
DateTimeDiff([reservation_status_date],DateTimeParse([arrival_date_year]+'-'+[arrival_date_month]+'-'+[arrival_date_day_of_month],'%Y-%B-%d'),'days')
sonyakasenkramer_0-1583784184853.png

 

Highlighted
8 - Asteroid

All,

 

I do not have a cool video, but I do have a solution

Spoiler
I used the Date Time Tool to convert the dates that I constructed with the Formula Tool. 
-Cheers!

Matt
Capture.PNG
Highlighted
8 - Asteroid

Thank you for the challenge! It was really interesting to deal with. 

Highlighted
Alteryx Certified Partner

Five minutes to do the challenge. 10 minutes for the perfect screenshot.

 

Spoiler
WorkflowWorkflow

The workflow isn't packaged #sorrynotsorry

Highlighted
Alteryx
Alteryx

Well that was easy.

 

Spoiler
RobertW_1-1583790286454.png

 

Highlighted
8 - Asteroid

Fun one.

Spoiler
challenge_206_mestevez.PNG
Highlighted
8 - Asteroid

Fun one

Spoiler
challenge_206_mestevez.PNG
Highlighted
8 - Asteroid
Spoiler
206_Amin.PNG

Highlighted
Alteryx
Alteryx

My solution. Not my usual style; I did it all in formulas just to be different.