AnsweredAssumed Answered

Calculating high season price

Question asked by MichaelA. on Aug 29, 2010
Latest reply on May 8, 2011 by NicolayFlaaten


Calculating high season price


Hello there,

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