Calculate month between dates Survey123

Question

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

@IsmaelChivite @JamesTedrick

Jim-Moore · Accepted Answer

Hi @FedericoRiet_Sapriza

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