Skip to main content
Nintex Community Menu Bar

How to clear datetime column in SharePoint list

  • August 25, 2016
  • 4 replies
  • 105 views

Forum|alt.badge.img+1

I have a datetime column in my list and in the workflow on a condition i need to clear (empty) the date time field. I tried to set 01/01/0001 00:00:00 but the column was not cleared and workflow not throwing error. Even i created a emty datetime column in the same list and try assigning value from that column but it is also no help.

 

Is there a way to clear the datetime value in the item?

4 replies

Forum|alt.badge.img+9

I have used "Set Field Value" and in the value section I made the datecolumn value as blank.I am able to clear datecolumns.I tried both for option datecolumn and mandatory datecolumn


Forum|alt.badge.img+9
  • August 26, 2016

Just need to create a blank variable - there is a post in here how to do it.

Basically, create Variable1 and Create Variable2 both blank text, then set Variable2 to be Variable1 and then you can use Variable2 to set a column to a blank value.


Forum|alt.badge.img+9

Are you able to fix the issue?


Forum|alt.badge.img+1

No I'm unable to fix this. So contacted Nintex support, they said we cannot clear date time fields in Nintex 365.

Regards

Praveen Prabhakaran