cancel
Showing results for 
Search instead for 
Did you mean: 

Empty date column with workflow

Automation Master
Automation Master
4 4 2,191

This works with on-prem Nintex Workflow 2013

Problem:  Upon archiving a document I use workflow to update the date/time field of when the archive happened.  When user wants to un-archive the document, I need to clear the date field to display as empty (or null).

Resolution

  1. Create variable vDateArchivedDate as Date and Time with blank default date
  2. Use Convert value action input "1/1/0001" and store in variable vDateArchivedDate
  3. Use Set field value to update the date column with workflow data > vDateArchivedDate
4 Comments
bamaeric
Nintex Newbie

Thanks Cassy. Just tried this out and it works great. Definitely adding this one to my bag of tricks!

joseph_cervi
Nintex Newbie

Thanks Cassy. I wanted to add that this works with the "Update item" action, but does not work with the "Update multiple item" action.  I am unable to find any workaround for the "Update multiple items" action to set a null date.

burkslm
Nintex Newbie

That is great!

ltaylor
Nintex Newbie

Is there a working solution for this yet in Nintex O365?