Hi
I'm trying to calculate the number of months between dates, but I don't get the correct answer I try with decimal and epoch time
This is the answer is get in Survey123, shouldn't be 24 months?
Thanks in advance for your help.
Cheers,
Federico
Solved! Go to Solution.
Thanks for the screenshot of your XLSForm. Try using the round() function in your calculation, instead of int(). As described in this GeoNet post, in the field app the int() function discards the decimal places. Here is the calculation split into a few questions - you can see the number of months should be rounded to 24:
Hope this helps,
Jim
Thanks for the screenshot of your XLSForm. Try using the round() function in your calculation, instead of int(). As described in this GeoNet post, in the field app the int() function discards the decimal places. Here is the calculation split into a few questions - you can see the number of months should be rounded to 24:
Hope this helps,
Jim
Hi Jim,
this awesome and very well explained!!!
Thanks so much!!
Cheers,
Federico