Problem 1: I need to build a SPD workflow where If ‘completed date’ is empty and ‘status’ field is ‘completed’, then fill in ‘completed date’ field with ‘modified’ field (‘when an item is created’, and ‘when an item is changed’).
Problem 2: SPD Workflows do NOT have the ‘is empty’ option on date fields. Whaaaattt?
Solution:
- In Step 1, use the ‘Set Workflow Variable’ action to create a variable called ‘CompletionDate’. Set this variable to Current Item:Completed Date, Return field as: As String.
- Then in Step 2 you will have a string variable that has the ‘is empty’ option …. see picture below:
