cancel
Showing results for 
Search instead for 
Did you mean: 
cvuppala
Nintex Newbie

How to check for an empty date field?

Jump to solution

Hi,

I have a requirement where I need to check for an empty date field. I do not see a direct way of doing this. One idea I have is to create a workflow variable (Date & Time) and set the default to "blank". Compare the date field against this variable. 

Is this the right approach?

Please advise,

Thank you

0 Kudos
Reply
15 Replies
Automation Master
Automation Master

Re: How to check for an empty date field?

Jump to solution

do you need to check it in forms or workflow?

Reply
lakshminarayana
Nintex Newbie

Re: How to check for an empty date field?

Jump to solution

Hi ‌,

you can use set a condition action to check date value is empty or not.

Thanks,

Reply
cvuppala
Nintex Newbie

Re: How to check for an empty date field?

Jump to solution

Workflow

0 Kudos
Reply
Automation Master
Automation Master

Re: How to check for an empty date field?

Jump to solution

then both ways, yours and ‌'s bellow are valid.

0 Kudos
Reply
Automation Master
Automation Master

Re: How to check for an empty date field?

Jump to solution

Hi,

I've just been looking at this in Workflow 2016 and both Run If and Set a Condition do not allow you to select "is empty" when checking against a date field. I think only string values are allowed to checked for "empty".

‌, is this by design? Are there older versions of workflow that do allow "is empty" against a Date type.

Reply
Automation Master
Automation Master

Re: How to check for an empty date field?

Jump to solution

have you checked with "Value" and date variable reference or with "Workflow Data" and date variable selected from dropdown?

the former allows to check for emptiness, the later not (at least in NW2013)

0 Kudos
Reply
akrasheninnikov
Nintex Newbie

Re: How to check for an empty date field?

Jump to solution

I think that's because DateTime type in .NET Framework is not nullable by default, so you can check for null in a CAML query with IsNull or IsNotNull (before you assign a value to a variable), but when you already have a datetime value, it's never empty.

Reply
Automation Master
Automation Master

Re: How to check for an empty date field?

Jump to solution

Querying the column directly

Reply
Automation Master
Automation Master

Re: How to check for an empty date field?

Jump to solution

does it allow you to change Condition dropdown to something like 'if any value equals value", like in former version(s)?

Reply