Challenge #206: Hotel Reservations

[MarkJackson]

スポイラ

[Trumble]

Solution complete, as streamlined as I could make it.

[mattjacobs]

Seems like i come up with a similar solution.  An interesting challenge, had to try something I hadn't done before with the DateTime tool.

[JasonHu]

スポイラ

Here is my submission.

[EFos]

スポイラ

[ncrlelia]

Challenge 206

[euanwilson]

スポイラ

[TheOC]

First weekly challenge in longer than I'd like to admit (I need to catch up to @Shifty)

スポイラ

[IraWatt]

Great Challenge !

スポイラ

[mceleavey]

Nice little bit of date parsing.

スポイラ

I first filtered the records down to show only those where the Reservation_Status is "Check-Out" then created the arrival date by smooshing the date elements together.
I then converted the arrival date using the conversion tool and calculated the duration by using datetimediff between the two dates.
Then it was a simple matter of filtering to those where the duration was greater than zero and summarizing accordingly.

M.