Skip to main content
Nintex Community Menu Bar

Empty date column with workflow

  • August 29, 2018
  • 4 replies
  • 232 views

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
Forum|alt.badge.img+14
  • Apprentice
  • 469 replies
  • August 29, 2018

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


Forum|alt.badge.img+5
  • 27 replies
  • August 30, 2018

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.


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

That is great!


Forum|alt.badge.img+1
  • 8 replies
  • October 4, 2018

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