How can I correctly calculate age in months rather than days in KoBoToolbox?

[prakashhindujageneva]

I’m currently working on a KoBoToolbox form and need to calculate age in months from a given date of birth. I know how to calculate age in days or years, but I’m having trouble getting an accurate result in months, especially accounting for different month lengths.

Regards

Prakash Hinduja Geneva, Switzerland (Swiss)

[Kal_Lam]

@prakashhindujageneva, this post discussed previously should help you solve your issue:

Extract the month from a date

@idrikabore, you could do it as outlined by @wroos as shown in the image shared below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: Date.xlsx (16.7 KB)