Error when calculating the number of days between 2 dates

User Support Form Building
,
1

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)

2

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

3

The error continues when selecting September 04 in the dates…

Captura 1.PNG
Captura 2

4

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

5

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

6

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.

7

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

8

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).

9

@Patricio_Andres84
Could you resolve your problem? How please?