Due Date is not equal to Tomorrow

Question

Hello all,

I want to compare the Due Date should not be tomorrow in SharePoint designer workflow. Can any one please suggest me how can I achieve it? I don't want the workflow to be fired when Due Date is tomorrow.

Eg: If Current Item:Due Date is not equal to Tomorrow

Thanks so much for your help!

- Cherry

Answer 1

You need to use the else / if statement in your workflow. Here is a video that may help.

https://www.youtube.com/watch?v=S77nOeutWCE

---

Thanks, Danny Hickman IT Support Specialist

Answer 2

Thank you for the response. But I would need to compare exactly like "If Current Item:Due Date is not equal to Tomorrow". Please suggest the way we can achieve this. Thanks again for your help.

Answer 3

Hi Cherry- two ways you can achieve this: using a calculated column. Have another column that is defaulted to today's date. Then make a calculated column that = today column - due date. In your workflow, check to see if that calculated column = 1. If so, perform your action.

Or you can use the add time to date function in your workflow and store that in a variable. Then check that variable before performing your action. See the following link for details:

http://sharepoint.stackexchange.com/questions/144232/add-days-to-date-in-sharepoint-designer

---

cameron rautmann

Answer 4

Thank you Cameron. I will try it.

Answer 5

Hi CherryP,

How is everything going?

Is there anything update about this issue?

If the reply is helpful to you, you could mark the reply as answer. Thanks for your understanding.

Best regards,

Sara Fan

---

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [e-mail]