You can have a caluclation field that has the end date subtracted by the start date.
Then have a summary field on the calculation field you created.
If I am understanding correctly.
Thank you for the prompt answer.
The case is however, different.
From the following field:
Ah, I see, Your date format is day, month, year.
In a script I can imagine how to do this with a loop.
So if you start with the current month and loop through each month till you get to that last month, you can do the date subtraction.
In the loop you will have to check if the month that needs calculating is part of the start, end, or inbetween months.
If it is the start month, do the subtraction from the start date to the last day of month.
If it is an inbetween month do the subtraction of the first day of the month to the last day.
If it is an end month do the subtraction between the first day of the month and the end date.
This will give you the last day of the month:
If I think of simpler way, I'll let you know.
Many times, it simplifies matters to have a table with one record for each day of the reservataion. Then you can simply count all the records for a given month to get the days reserved. This can also be a very useful table for checking for room availability.
Thank you, it works.