Please help me, i want to compute the lenght of years in service of a certain employee, what i did i entered the year (2005-06-07) based on the picture and subtract it to the current date, the output was supposed to be 21 years.
Hi @jerfabre76 and welcome back
It seems like right now you’re counting the days passed since the date you wrote.
There are various approaches to calculate years, mostly discussed in calculating age threads.
You can see some of them below:
Hi Team members, I was creating a survey with Variables Date of Birth and Age. Is it possible to autogenarate Age in Years and Months from the date of birth entered?
…
Q3. Enter date of birth (dd/mm/yyyy): //_________
…
Q5. Current Age: Years:________________ Months:____________
Thanks
Collins
Hello team!!! I have a situation in my data. There was need to include a calculate field, to calculate age of child using date of the survey and date of birth in building the form however, I didn’t realise that I have not included it. Data collection has been completed and noting that there is no variable age of the child but is it key in calculating Z-Scores for Malnutrion indicators. The Date of the Survey was collected in the form: 04/12/2023 11:06:59 AM; 04/12/2023 11:29:33 AM, and 04/12/2…
You can find many of them by searching calculate age in forum.
Thank you very much sir for your response, I was able to fix it. I just divide it with 365 (days) and it works🙂
1 Like
