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

Create a Condition for Date field populated

Jump to solution

I have a workflow on a SharePoint Library and I want to set up a Condition that has Actions only if a Date field in the Library is populated. I can't seem to set a Condition on a Date field that says "is not empty" or "is empty" - I can only do this on Text fields. I also tried populating a text Variable with the date, so that I can set the Condition on the Variable as "is not empty" or "is empty" but that doesn't seem to work either. Anyone else have this issue? Is there a workaround?

Labels: (2)
Tags (2)
0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: Create a Condition for Date field populated

Jump to solution

Hello,

The Text variable approach should work, but what you are probably running into is a default date/time is being stashed into the variable when you set the one equal to the other.

Log out to History your Text variable for the default that it is being assigned, so instead of "is empty" you can compare it to that default (which means it wasn't set by the user) and can therefore carry out your conditional logic.

Hope this helps,

Mike

Reply
mjterrell
Nintex Newbie

Re: Create a Condition for Date field populated

Jump to solution

Is there a form associated with this? Or just a workflow?

Reply
tschaef
Nintex Newbie

Re: Create a Condition for Date field populated

Jump to solution

The date field is a Date column in a SharePoint library. I only want to trigger the workflow when there is a date in this column for each file in the library.

0 Kudos
Reply
tschaef
Nintex Newbie

Re: Create a Condition for Date field populated

Jump to solution

This helped, Mike, along with another posting I found at https://community.nintex.com/message/53789-q.

I created a Date Variable (dtEndDate) and a Date Variable (dtSPEmptyDateValue) where I specified the Default date as 1/1/0001 12 AM 00; added the "Set variable" action where "Set" is "dtEndOfLife" Equals "List Lookup" and chose the Date column from the library (End Date); then I added a "Set a condition" action with the Condition "If any value equals value" Where Value "(dtEndDate)" equals "dtSPEmptyDateValue" and I added the actions I wanted to happen under the "No" nodes and left the "Yes" nodes empty.

0 Kudos
Reply
Automation Master
Automation Master

Re: Create a Condition for Date field populated

Jump to solution

Exactly

Reply