How to check if Date column is null in workflow sharepoint 2010?

Question

In Infopath I have a Date Column which i need to check in workflow like if date column is empty i have to stop the workflow. How to achieve this?

I tried using setting variable and parameters but none works.

ScreenShot:

Could you please share screenshot of workflow actions where you have set variables and ended workflow? — 404, Dec 2, 2015 at 5:42

Atish Kumar Dipongkor · Accepted Answer · 2015-12-02 06:58:43Z

3

Can you try following. I have just tried it. It may meet your requirement.

Create a calculated column named IsEmptyDate or anything you like which outputs text.

Paste the following formula.

=IF(ISBLANK(StartDate),"Y","N")

After applying this formula, my list looks like following and that helps me to believe it should work.

answered Dec 2, 2015 at 6:58

13.4k5 gold badges31 silver badges64 bronze badges

Add a comment |

Amit Kotha · Accepted Answer · 2015-12-02 06:01:01Z

1) Create another list column of type Date and Time called EmptyDate, using the default settings, except deselect Add to default view.

2) Use this field to compare to your date field in the workflow condition, using equals or not equals:

3) Hide EmptyDate from users by not adding it to any views. Also, hide it from the view/edit form by following these steps:

4) Go to List settings -> Advanced settings and ensure Allow management of content types is set to yes.

5) Go back to the List settings page and click on Item in the Content Types section of the page.

6) Click on EmptyDate in the Columns section of the page.

7) Select Hidden (Will not appear in forms).

2 Answers 2