Using SPD to update date field when field is empty RRS feed

  • Question

  • I'm new to SPD and need to create a workflow with the following conditions/actions, and am having difficulty with the proper placement of order.  

    Action items are assigned to users, and we are finding that these two fields are not always updated when an item is closed out.

    Two fields:

      • Status (active or closed)
      • Closed Out Date

    What we need is:

    If status fieldlosed out date field is empty, populate closed out date with today's date, else ignore

    If Close out Date field  is populated, and status field is empty, update status field = closed, else ignore

    Can someone guide me to the proper steps.

    thank you !

    Monday, September 3, 2012 4:51 PM


  • Hi Kim,

    You can create the workflow similar like the step in below image.

    1. Close Out Date variable is a workflow variable with string type. I use it to get Closed Out Date field’s value. Because when Closed Out Date is empty, it still store date like this: “1/1/0001 12:00:00 AM”.
    2. Set default value to Status to blank. Otherwise, if it is field with choice field, it will hardly to be an empty field. You can also modify the condition to: If Current Item: Status is not equal to “closed” to make it work.

    Let me know if you have any question.

    Thanks & Regards,

    Emir Liu

    TechNet Community Support

    Tuesday, September 4, 2012 6:33 AM