none
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


    • Edited by CherryP Friday, February 03, 2017 4:15 PM
    Friday, February 03, 2017 4:13 PM

Answers

  • 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

    • Marked as answer by CherryP Thursday, February 09, 2017 4:01 PM
    Friday, February 03, 2017 6:16 PM

All replies

  • 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

    Friday, February 03, 2017 4:37 PM
  • 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.
    Friday, February 03, 2017 5:45 PM
  • 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

    • Marked as answer by CherryP Thursday, February 09, 2017 4:01 PM
    Friday, February 03, 2017 6:16 PM
  • Thank you Cameron. I will try it.
    Monday, February 06, 2017 6:13 PM

  • 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 tnmff@microsoft.com

    Thursday, February 09, 2017 8:34 AM
    Moderator