Workflow Hero

Datedif not showing Negative Numbers

Hoping you can help!


I have a calculated field where I want to show the number of days between 2 dates.  Pretty simple.

However, if there is no date in either of the fields, it shows a "#NUM!" error.  I figured that out:




Now my problem is if the difference is a negative number, it shows the same #NUM! error.  How can I work that in to show a "-#" days?


0 Kudos
1 Reply
Nintex Employee
Nintex Employee

Re: Datedif not showing Negative Numbers


Your formula looks like something out of Excel.
Nintex does not have an isblank or dadedif function.
0 Kudos