Challenge #206: Hotel Reservations

[MarkJackson]

Spoiler

[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]

Spoiler

Here is my submission.

[EFos]

Spoiler

[ncrlelia]

Challenge 206

[euanwilson]

Spoiler

[TheOC]

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

Spoiler

[IraWatt]

Great Challenge !

Spoiler

[mceleavey]

Nice little bit of date parsing.

Spoiler

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.