Changing discount at the end of three month period

Topic Labels: Formulas
750 2
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

I currently have the following formula running since January that I want to be active for all bookings up to up the end of Mar 2021.

{Extrachildren} * MIN(({Weeks FM/Zoom}+{WeeksSR}), 10) * 5

For April until June I want this formula to be active

{Extrachildren} * MIN(({Weeks FM/Zoom}+{WeeksSR}), 11) * 3

Can somebody tell me how I achieve this.

2 Replies 2

Hi @Philip_Barber

Is it an option to use an if() in your formula and using a date/date of record creation/today()/… as a parameter to determine which formula to use?

Thank you for your suggestion but I have just agreed with another helper that I like their solution of using SWITCH as a solution. Unfortunately the solution will not safe currently but I am sure that it must be something I am doing incorrectly.

Screenshot 2021-03-07 at 09.34.13

At a later stage I do want to check a booking date and use a formula to assign the correct Qtr but that is jumping ahead of myself, unfortunately I really am not good enough to do any formula myself.

Thanks for you suggestion but it was not clear enough for me to fully understand the option.