Calculate date based on selection in a choice list

  • 31 March 2020
  • 1 reply
  • 3 views

Badge +4

I want to add a Calculated field to my Form that takes the Current Date and adds either 14 days or 28 days, based on a choice list (radio button) that looks like this:

 

Next check-in date:    2 weeks       4 weeks

 

How can I do that calculation based on which option the user picks?

 

Thanks in advance.


1 reply

Userlevel 6
Badge +22
Hi,

If your Choice control was Named "HowLong" the formula would be:
dateAddDays(Current Date,If(equals(HowLong,"2 Weeks"),14,If(equals(HowLong,"4 Weeks"),28,0)))

Reply