Skip to main content
Nintex Community Menu Bar
Answer

Set Date field to null in Office 365 workflow

  • January 3, 2019
  • 6 replies
  • 104 views
S
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 

    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?

    E
    Forum|alt.badge.img+17
    • eharris04
    • January 4, 2019

    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?

    S
    Forum|alt.badge.img+2
    • spothire475
    • Author
    • January 4, 2019

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

    S
    Forum|alt.badge.img+2
    • spothire475
    • Author
    • January 4, 2019

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

    B
    Forum|alt.badge.img+2
    • ben_nadler
    • 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 

    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.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement