Auto generating age in years and months from Date of Birth

mahrukhkhan · August 21, 2019, 11:20am

I have the exact same question as asked by @Collins. I am having a hard time in understanding your code - where do I paste it in my Excel form?

I have two date variables : 1) date of survey and 2) date of birth

Would really appreciate if you could help me understand this.

Thanking in anticipation.

stephanealoo · August 21, 2019, 2:06pm

Hi @mahrukhkhan

That was such a long time. There is now an article that clearly describes how to do advanced calculation. Kindly check on it here and if you don’t find your solution, please type your question and example so that we can chime in on it.

Regards
Stephane

mahrukhkhan · August 21, 2019, 3:04pm

Hi @stephanealoo,

Actually my question is not just about the calculation of dates. It is about the display of the calculation in Years, Months.

I have a date variable which opens up the calendar to enter date of survey.
I have another date variable which opens up the calendar to enter the date of birth.

I then calculate the age by subtracting the date of birth from the date of survey. In my data set, if the child is 15 months old, the age displayed is “15 months”. However, I want the display to be “1 year 3 months”.

Is it possible to do this on Kobo?

Please let me know if there is a solution to this.

stephanealoo · August 21, 2019, 3:38pm

Hi
I created a form just to explain this find it attached hereCalculateExamples.xls (26 KB)

Focus on the area shown below

Your output should be something like this

And as indicated by @Xiphware FYI depending on how pedantic you wish to be, you might be interested in this thread (specifically discussing leap years…). But since you just want years and months here - that is, the precise number of days doesn’t matter - the impact of leap years will be nominal.
Regards
Stephane

mahrukhkhan · August 21, 2019, 5:38pm

That worked. Thank you so much @stephanealoo! Really appreciate your effort.

Xiphware · August 21, 2019, 11:04pm

FYI depending on how pedantic you wish to be, you might be interested in this thread (specifically discussing leap years…). But since you just want years and months here - that is, the precise number of days doesn’t matter - the impact of leap years will be nominal.

mahrukhkhan · August 22, 2019, 4:38am

Hi @Xiphware,

Thanks for the link. This is super useful!

stephanealoo · August 22, 2019, 6:44pm

@Xiphware adding this component to the solution

Simakechula · February 18, 2020, 1:08pm

Dear @stephanealoo, about age calculation, how does one do it directly from the KoBoToobox form generation to get this kind 0f form preview as per your post. The article on Advanced Use of Calculate Questions does not seem to explain well.

stephanealoo · February 18, 2020, 3:02pm

Hi,
You should use the same principle used in the previous form, the only difference would be that you are adding this on the form builder as opposed to an XLS form.

You will need to create a calculate question from the form builder
You will then have to type your formula in the bar. Remember to use the reference to the previous questions that have the date of birth and date of interview. Please note that the formula will be the same as to the one you could have used in XLS

image907×315 11.6 KB

You will simply type the following into the calculate (${interviewdate}-${birth}) div 365

Unfortunately when working with FormBuilder you can not create calcuations on other types of questions such as text or integer, you must create it on calculate questions. When viewing the form, calculate questions will not be shown.

Stephane

Simakechula · February 18, 2020, 3:16pm

Received with thanks @stephanealoo. Will keep you posted on how it goes.

aahmed · March 26, 2021, 4:18pm

Hi stephanealoo, thanks very much for helping with the auto age calculation. I have prepared a short version of this for testing and it works.

stephanealoo · April 7, 2021, 4:58pm

@aahmed
I am glad that this was still helpful one year down the line

Stephane

tba · October 5, 2021, 12:50pm

Hi
Find a shorter solution

date	dob	What is your Date of Birth?
calculate	age_years	Age in Years	int((today() - ${dob}) div 365.25)
calculate	age_mnths_remainder	Age in Months Remainder	int((today() - ${dob}) div 30.44) mod 12
note	age	${full_name} is ${age_years} years and ${age_mnths_remainder} months old

Kal_Lam · October 5, 2021, 12:53pm

Thank you for sharing this wonderful solution with the entire community, @tba! Expecting the same in the upcoming days too.

anilgnydn · December 7, 2021, 7:57am

Hello @stephanealoo in your example is it possible to calculate age by using current date(Meta data) instead of interview date.

I want end user to provide me only date of birth in date format then in the backend I want to subtract date of birth from today’s date. Can you provide me the right formula for this ? many thanks!

wroos · December 8, 2021, 7:57pm

Hello @anilgnydn,
Using today() function together with the birthday will give you the (dynamic) age of today. Which might be different of this person’s age tomorrow already (or the one of a tomorrow submitted person with the same birthday) in your backend. But NOT the age at interview.
Do you really want this?
Also be aware that metadata ${today} acts differently to today() function.