Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #206: Hotel Reservations

nmacpherson
6 - Meteoroid
Spoiler
nmacpherson_0-1583783375047.png

 

sonyakasenkramer
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

 

Reesetrain2
9 - Comet
9 - Comet

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
dpencheva
8 - Asteroid

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

PhilipMannering
16 - Nebula
16 - Nebula

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

 

Spoiler
WorkflowWorkflow

The workflow isn't packaged #sorrynotsorry

RobertW
Alteryx
Alteryx

Well that was easy.

 

Spoiler
RobertW_1-1583790286454.png

 

mestevez1
8 - Asteroid

Fun one.

Spoiler
challenge_206_mestevez.PNG
mestevez1
8 - Asteroid

Fun one

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

TonyA
Alteryx Alumni (Retired)

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