dateDiffDays issue

Hi,

I've got a problem with DateDiffDays function in Nintex Forms.

I want to do the days difference between the first week of this year (04/01/2021) and an other date.

It works well until the 29/03/2021.

For the 28/03/2021, the function returns 83 days and the same for the 29/03/2021 that should be 84.

Any known solution for this bug ?

Thanks for help,

Thomas

Here is another sample issue with dateDiffDays function on Nintex form. Both of the following calculations return the same result:

dateDiffDays("3/13/2023","3/14/2023") = 1
dateDiffDays("3/12/2023","3/14/2023") = 1

Solution:

Alternative formula that I came up with which works for me that you may want to give it a try:

Round((EndDate - StartDate)/86400000, 0)

Note: 86400000 is milliseconds in a day.

Best,

anho

Sign up