Skip to main content

Hi Team,

Need help with a validation rule for my form

I have a request form that has preferred dead line field ( date field),if preferred deadline is within 5 days of the request  the form should not be submitted.

At the same time there is a choice field in the same form, if one of the choices is selected the rule for the date field should not be applied .  

I have used this formula for the date field Formula Builder

dateDiffDays(Start Date,Preferred Deadline)<=5))

I am not sure how to exclude this rule for those choice from that choice field

any help much appreciated

Thanks!!

What choice type are you using?

Here i am assuming check boxes. Write a validation rule for 'Preferred Date' control.

                                                              If date diff. is not less than 5 days

211133_pastedImage_6.png211130_pastedImage_3.png

If date diff. lessthan 5 days and with choice value.         If date diff greater than 5 days.

211131_pastedImage_4.png211134_pastedImage_7.png


Reply