Skip to main content
Nintex Community Menu Bar

How to check if a date field is null in Nintex Form

  • June 17, 2021
  • 5 replies
  • 718 views

Forum|alt.badge.img+7

I have a Nintex Form in SharePoint 2016. The form has a date field and a user is required to enter a date. How do I put that validation. IsnullorEmpty does NOT work on date field.

 

Thanks.

 

Mayank

5 replies

Forum|alt.badge.img+12
  • Rookie
  • June 17, 2021

@guru2000 if you don't want your user to leave it empty then make that column which is connected to your date control as required.

 

Also, on the date control, if you open the control setting then under Validation, there is an option Required.


Forum|alt.badge.img+7
  • Author
  • Rookie
  • June 18, 2021

Thanks Kunal, Here is what I want,

 

I want the date field to be required based on a condition. Sometimes the date field is required and other times it is not.

 

What kind of rule do I need.


Forum|alt.badge.img+12
  • Rookie
  • June 19, 2021

@guru2000 you need to use the validation rule. Try using with If function. Also, I don't know what's your condition so couldn't help you much.


Forum|alt.badge.img+7
  • Author
  • Rookie
  • June 28, 2021
What is the validation rule to make sure that a user selects a date from a Date field. Isnullorempty does not work. Thanks Kunal.

Forum|alt.badge.img+12
  • Rookie
  • June 29, 2021

@guru2000 I'm little confused !!!! If you want to use Isnullorempty then it means under no circumstances user can leave that empty, if that's your requirements then below are 3 different ways to do it:

 

  1. Make connected SharePoint column as required
  2. Go to control's settings and expand validation and make it required (you won't get named control tab when you use expression choice in required dropdown)
  3. Create a rule on the right side for the date control using "{Self}" from named control and Isnullorempty function apply the rule (see below screenshot)

     

     

But, if the date control is required based on some other control's value then you need to tweak above option # 3 accordingly.