Skip to main content
Nintex Community Menu Bar
Solved

Set Date field to null in Office 365 workflow

  • January 3, 2019
  • 6 replies
  • 133 views
  • Translate All
Forum|alt.badge.img+2

Hi Eric Harris, Lisa 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.

Best answer by ben_nadler

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 

View original

    6 replies

    lisatam
    Nintex Employee
    Forum|alt.badge.img+3
    • lisatamNintex Employee
    • Nintex Employee
    • January 4, 2019

    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?

    Translate
    Forum|alt.badge.img+17

    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?

    Translate
    Forum|alt.badge.img+2

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

    Translate
    Forum|alt.badge.img+2

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

    Translate
    Nintex Partner
    Forum|alt.badge.img+2
    • ben_nadlerNintex Partner
    • Nintex Partner
    • Answer
    • January 4, 2019

    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 

    Translate
    Bards
    Forum|alt.badge.img+6
    • Bards
    • Rookie
    • July 16, 2020

    I've tried this solution and it works - but only if you match on ID column with the match 'is equal to' ID value (either hardcoded or variable). It fails for me to find a match on any other field type.

    Translate
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement