Calculating high season price
in my case Filemaker is used for manage apartment reservation and booking. There is a formula used for calculating weekly and monthly price. (Look screenshot) So far no problem. Now i was ask if i can change the calculation that the formula consider high season prices for summer and easter holidays. The calculation is using the count of nights between check in date date check out date. My question now is how i check if the date between check in and check out overlaps with the high season period and add the higher price only for the nights which is in the period to the normal price? I hope i explain it clear.
Thanks for help y saludos, Michael