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…
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?