Skip to main content
Nintex Community Menu Bar

If date is blank or is error - Code

  • February 4, 2021
  • 0 replies
  • 5 views
J
Forum|alt.badge.img+2

I have a calculated column made to show how many days overdue is a permit. Right now if the permit expiry date is not picked it is giving 44,265 days overdue due to the date being 12/31/1904. I want to put if isblank "" but I am not sure where to insert that in the code.

 

=IF(ISERROR(DATEDIF([Permit Expiry Date],Today,"d")),"0",(DATEDIF([Permit Expiry Date],Today,"d")))

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