Error when calculating the number of days between 2 dates

Greetings to all.

I have a form that automatically calculates the number of days between 2 dates, it works without problems in all months, except in September, when within the range of selected dates is September 04, it does not consider it in the calculation.

It uses as a basis for the calculation the formula that appears in the attached xls that you provided in the community forum, but it has the same problem when selecting September 04.

I would appreciate if you could help me to solve this problem.

Calculate Days.xlsx (15.2 KB)

Welcome back to the community, @Patricio_Andres84! Have you tried this approach discussed previously:

The error continues when selecting September 04 in the dates…

Captura 1.PNG
Captura 2

Might this have a relation to the change for the Kobo OCHA server?

Can you try to convert your date variables in the calculations with the date(…) function?

I made several tests, but when I included September 04 in the date range, the problem reappears… with other date ranges the function works without problems.

Which country/timezone do you test it?
Which server do you use and which browser?

I use it in Chile/UTC-4, I use the non-humanitarian global server, I use Chrome as browser (I also tested it in Explorer and Firefox).

Could you resolve your problem? How please?