AndyC
Rookie

Clearing a date field

I have a SharePoint list that has an associated workflow that on list item change will start the workflow, this works properly for the most part but i am having an issue that when someone edits the items and changes the Status to power off it should clear the Requester, Date Requested, Power Off Date and business Reason fields.

 

The  Requestor and Business Reason are cleared using an update item which sets their value to a null text variable.

 

The dates however I cannot clear.

AndyC_0-1637257255503.png

I have tried the following methods:

  1. Used "Update List Item" create a variable called nullDate with a short form date with no date assigned to it and then update value against this variable.
  2. Used "Update List Item"  and tried setting date to an empty string  and then update value against this variable.
  3. Created a new column called "BlankDate" which is a date field with no set date in it and then tried an "Update List Items" and set the value against this field as empty/blank (this causes error in workflow as requires a value)
  4. Tired above 3 methods but using "Office365 Update Items" instead 

None of these work and the Date Requested and Power Off Date fields remain with their values in the list.

 

Any assistance or help to solve this would be greatly appreciated.

 

Regards,

Andy

 

 

 

0 Kudos
Reply
1 Reply
kunalpatel
Collaborator

Re: Clearing a date field

@AndyC can you try below steps?

 

  1. Create a workflow variable
    1. Name your variable
    2. Select Date and Time as a Type
    3. Select "Specify Date" in Default Date
      1. Delete Date
      2. Leave the time as is ( i.e. 12:00AM)
0 Kudos
Reply