Capturing count of records for a date between two dates

Hello awesome people,

I am stuck with this problem where I have records of hotel bookings, where I need to find the bookings that happened for a particular day. For eg, A booked hotel from Jan 1 - Jan 5, B booked the same hotel from Jan 3 - Jan5 and C booked the hotel for Jan 3. I would like to know the number of bookings for Jan 3 and the count should be Count = 3.

The table has a booking id, from date to date as columns. What do you think is the best way to approach this problem to find out the count for January 3rd?

0 3 7,763
3 REPLIES 3
Top Labels in this Space
Top Solution Authors