Skip to main content
Nintex Community Menu Bar

How to calculate date according to the choice field?

  • November 29, 2017
  • 1 reply
  • 11 views
Forum|alt.badge.img+5

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!!

    1 reply

    Forum|alt.badge.img+9

    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

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement