Using Date of birth to restrict further capturing

[bkgwadi]

1. What is the problem? Be very detailed. Failing to control further entry by using date of birth

2. What app or server are you using and on what device and operating system? Include version numbers.

3. What you have you tried to fix the problem?
Date Check.xlsx (36.3 KB)

4. What steps can we take to reproduce the problem?
Attempted to use int((today() - ${respondent_dob}) div 365)
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below. I want to use date of birth as a means of preventing further capturing of data if the respondent is below 15 years

[danbjoseph]

Leap years and such make it challenging to calculate age. Can you ask the respondent's age and then use that answer to control the rest of the survey?

Calculate age

The following will calculate the age, in days, from their date-of-birth: calculate = "round(decimal-date-time(today()) - decimal-date-time(${dob}))" (I round because due to floating point truncation you can sometimes get a difference of, say, 1233.999998 days. If you blindly truncate this you could end up a day off). Although it seems innocuous to be asking for months and years, in reality the question is ill-posed. Specifically, what precisely is a "year"? Some years can be 365 days, others…

I've modified your survey to use the int((${doi} - ${respondent_dob}) div 365) to calculate the age. And you can see that it doesn't work sometimes if the month/day of the two dates are close.
age_check.xlsx (14.2 KB)

Correct:

Wrong:

Correct:

I played around and I think the following works? If there's a less complex way to do it, I'd be interested to know. The narrative logic below is what I tried to implement in age_from_dates.xlsx (9.0 KB).

if birth month < than current month  
  then age is current year - birth year
  else if birth month  > current month
      then age is current year - birth year - 1
      else if  birth day > current date (we now assume birth month = current month)
        then age is current year - birth year - 1
        else age is current year - birth year