guru2000
Canvas Initiate

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

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

0 Kudos
Reply
5 Replies
kunalpatel
Automation Master
Automation Master

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

@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.

0 Kudos
Reply
guru2000
Canvas Initiate

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

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.

0 Kudos
Reply
kunalpatel
Automation Master
Automation Master

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

@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.

0 Kudos
Reply
guru2000
Canvas Initiate

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

What is the validation rule to make sure that a user selects a date from a Date field. Isnullorempty does not work. Thanks Kunal.
0 Kudos
Reply
kunalpatel
Automation Master
Automation Master

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

@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)

    Date_Req_SC01.jpg

     

    Date_Req_SC02.jpg

     

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

0 Kudos
Reply