Skip to main content
Nintex Community Menu Bar

Empty date column with workflow

  • August 29, 2018
  • 4 replies
  • 292 views
  • Translate All

Forum|alt.badge.img+16

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 replies

bamaeric
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • August 29, 2018

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

Translate

Forum|alt.badge.img+5

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.

Translate

Forum|alt.badge.img+11
  • October 4, 2018

That is great!

Translate

Forum|alt.badge.img+1
  • Nintex Partner
  • October 4, 2018

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

Translate