I have a reservation from 20.06.2021 to 14.08.2021
in a procedure that I have broken down by the interval of the months and I calculate the days for each month
in this case the months of June, July and August are concerned
to better understand the table that I present to you I will explain
in the first two columns there are the dates of the months: the month of June would start from the 15th because it is the 15th that is the date of the season
the calculation of days is calculated how many days in that period ie for example
from 15 June to 30 June the reservation interval (20.06 -14.08) is 11 days
the column 5 is a code that determines the type of season 02 is low 01 is high
you can observe in column 3 the total of the days
if you do a little math the total is 56
the customer insists that the days are actually 55 because he used the windows calculator you see below
then if I go to do in fwh
nGiorni:=(dLast-dFirst) give me 55
what is the right calculation?
that is, I can't explain to the customer that the date range from 20.06 to 14.08 is 56 because the same 20.06 is also counted
while the microsoft windows calcculator makes the difference of the days between those dates by not counting the 20.06 day