count based on start and end date

[surajap123]

Hi Experts,

I want to count the occupancy(ie 'Booking' field) for each week.

My table has From and ToDate of each booking.

I am not sure how to count the bookings falling between start and end date of the week?

[#2]

Hi Suraj

use the function InWeek

it gives true if the date is in the week

best regards

Chris

[#3]

Maybe master calendar and intervalmatch in load script?

Or calenadar as an island table ....

[its_anandrjs]

Hi,

I suggest you have to use any master calendar for this and then check the expected date for the given ranges.

Regards

[surajap123]

Thanks everyone for the suggestions. I have build the master calender, but still not getting the right count of 13 for RoomID 1065.

Infact i want to get the BookingID count per week.

I am not sure how i can add interval match to the script., i am attaching the modified app and source data. !