Age from Date

[gscart]

A formula (KOBOTOOLBOX) that works can be used to automatically determine age from a selected date. The date should be limited to 1924 to 2007 and the age range should be between 18 and 100. Thanks!

[Dnes]

Hello gscart,

you could do it as outlined in these posts discussed previously .

Hope this helps you.

Regards,
Dinesh Dongol

[Kal_Lam]

@gscart, this post as suggested by @Dnes should help you solve your issue:

Want to hide the DOB after calculating age once the forms is submitted to the server

Welcome back to the community, @cprosperi! You could do this as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: you still have not triggered the submission [Image 2] Data entry screen as seen in Enketo: you have now triggered the submission [Image 3] Data as seen in DATA>Table: age seen but DOB has been hidden [Image 4] Reference xlsform: Age Calculation.xlsx (9.8 KB)

[gscart]

Good day, I apologize, but this is not the outcome I was anticipating. To ensure no confusion, I’ll provide a list below.

1. Age is calculated automatically using the birthday calendar.
2. The age limit is restricted to 15 to 60 years only.
3. Restrict the calendar to the period between 1964 and 2009.
4. The age row should be limited to a note. Typing a text or number should not be possible for the user.

Is it possible that the file name of the photos they included is dependent on the label?

Thank you, this is a significant aid to our Scholarship Online form.

[Kal_Lam]

@gscart, seems like this is something what you are seeking for …

Validating date entry

Adding this line should solve your issue: In the survey tab of your XLSForm: [image] Data entry screen as seen in Enketo: when a wrong entry is made [image] Data entry screen as seen in Enketo: when a correct entry is made [image] Reference XLSForm: Calculate Age.xlsx (9.9 KB)