cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Set Date field to null in Office 365 workflow

Jump to solution

Hi Eric HarrisLisa Tam Support Technical Issues

I am trying to update date field to null using nintex workflow o365, but no luck. can anyone faced the similar situation before. 

I tried in many ways.

1. assigning the date to a empty Date/time variable - no luck

2. Created another date column with empty value and assigned this to date field - no luck

3. currently using the Office 365 Update items action and its giving me an error when trying to write a filter condition.

Your comments are appreciated.

-Sudheekar.

Labels: (1)
0 Kudos
Reply
5 Replies
Workflow Hero

Re: Set Date field to null in Office 365 workflow

Jump to solution

Hey Sudheekar, I remember reading somewhere that it works if you set the date value to "0000-00-00", can you try and see if that works?

0 Kudos
Reply
Community Manager Community Manager
Community Manager

Re: Set Date field to null in Office 365 workflow

Jump to solution

Why zetia a value to null? That seems a bit backwards because null is no value, so you can't really set a value to no value.

Are you trying to remove a value?

0 Kudos
Reply
Workflow Hero

Re: Set Date field to null in Office 365 workflow

Jump to solution

Yes Eric, i am trying to remove the date. Just a note i am working in O365 site. Thanks again.

0 Kudos
Reply
Workflow Hero

Re: Set Date field to null in Office 365 workflow

Jump to solution

Hi Lisa, I tried to set the date value to "0000-00-00", but its not accepting in this format.

0 Kudos
Reply
Workflow Hero

Re: Set Date field to null in Office 365 workflow

Jump to solution

You can do it if you use the Office 365 Update Items action. 

See below for configuration settings. You just need to create your own Connection and change the field name from External Review Date to whatever field you are trying to blank out 

0 Kudos
Reply