Skip to main content

I'm trying to compare two dates (Date A - Date 😎 and calculate days using Nintex form. I'm using "dateDiffDays"  runtime function to get days count. But it is not showing negative sign when Date A is smaller than Date B.

So this formula works to show positive, but need to find a way to show minus.

Thanks,

Swapnil

It seems to be a bug.


Hi,

I don't know if this is a bug. It has certainly behaved this way for quite some time. My take on it is that the function name is dateDiffDays, which means that it is showing the difference between the two dates. The difference is the difference, not a positive or negative! wink.png

Anyway, try something like the below, which should give you the result you are chasing:

If(greaterThanOrEqual(date A,date B),dateDiffDays(date A,date B),-dateDiffDays(date A,date B))

Cheers,

Mark


Thanks Mark. It is working now. happy.png


Yes it is.


Glad I could help!


Reply