Calculate month between dates Survey123

[FedericoRiet_Sapriza]

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 solution]

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

[FedericoRiet_Sapriza]

Hi Jim,

this awesome and very well explained!!!

Thanks so much!!

Cheers,

Federico