Trying to build a workflow that clears a date column when the task "Completed" box is unchecked.

Have tried several different approaches but have not gotten anything to work. The workflow completes after the "Completed" box is unchecked but the date is not cleared from the column.

There is no option to select a NULL value, have tried setting an "empty" calendar date but that just defaults to the default date value (undesired) but even then the date is still not cleared.


Thank you!

  • 2
    I think that the problem is that a date columns is really never "empty" in SharePoint. Instead it is set to something like 1/1/0001". One solution could be to have an additional date field that's hidden and empty. When you wanna clear the value in your date column, set it to the hidden empty date columns value. Jan 28, 2016 at 14:12

2 Answers 2

Solution 1:

It cant be done. Better off using a text column and ensure that its populated by well coded actions (meaning only valid dates with proper formats gets saved).

And since its a text column, you can always clear it.

Solution 2:

Default it to 1/1/0001 (if its the default). Then modify your code/workflow/view to filter rows based on the column value != 1/1/0001


Just a thought, you could create an empty/blank variable (of type Date-Time) and then set the column value to equal your variable.

Hope this helps

  • Thank you. I tried to do this but it got populated with the default date value 1/1/0001.
    – Alexx
    Feb 1, 2016 at 19:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.