Cognito-forms – Exact age calculation in Cognito Forms (not rounded to the nearest neighbour)

cognito-forms

I used the following formula provided with modification:

Form.CampDate.Year - BirthDate.Year + (DateTime.Today.Month < BirthDate.Month or (DateTime.Today.Month = BirthDate.Month and DateTime.Today.Day < BirthDate.Day) ? -1 : 0)

I need the return result to show year and month—how do I go about it?

Example: my event date is 06 June 2016 and the birth date is 10 July 2012, so the result should be 3 years 11 month or round to age 3.5 instead of capture as age 4 year. What’s the correct Cognito Forms formula for this result?

Best Answer

Calculating Age in Cognito Forms

You can use the following calculations to determine the age of someone based on a birth date in when writing calculations in Cognito Forms. This is the official accurate way to calculate ages without rounding or mistakes due to leap years.

Age in Years

= DateTime.Today.Year - BirthDate.Year + (
if DateTime.Today.Month < BirthDate.Month or 
(DateTime.Today.Month = BirthDate.Month and 
DateTime.Today.Day < BirthDate.Day) then -1 else 0)

Age in Months

=(DateTime.Today.Year - BirthDate.Year) * 12 + (DateTime.Today.Month - BirthDate.Month) + (if DateTime.Today.Day < BirthDate.Day then -1 else 0)

Age Description

="You are " + AgeInYears.ToString("d") + " years and " + (AgeInMonths - AgeInYears * 12).ToString("d") + " months old!"

If you put the birthdate of the Statue of Liberty into these calculations, you will see that she is 129 years old today!

You can see these calculations in action on this shared form template: https://www.cognitoforms.com/templates/shared/CognitoSupport/AgeCalculations

Related Solutions

Cognito-forms – Calendar calculation in Cognito Forms

I am a developer for Cognito Forms.

Since February 2015 the following functionality has been made available:

In this example, I am setting the range on the Start Date field to =DateTime.Today. It could have also been =DateTime.Today.AddDays(1) to be tomorrow or later. Calculations are very robust and should cover most scenarios you can dream up, but you can also just enter literal dates.

range field

I then set the range on the End Date to be at least three days after the Start Date, but no more than seven days. Here is the calculation for the End Date minimum:

setting end date minimum

And this is how the Start Date appears on the form, with the days before today disabled:

calendar with days disabled

And similarly for the End Date, with both minimum and maximum date restrictions based on the Start Date.

calendar with days after disabled

The date range for the End Date automatically updates based on changes to the Start Date, so if an End Date is specified and the Start Date is later changed, validation will catch this if the user does not fix it first.

end date validation

Please note that range validation applies to Date, Number and Currency fields, not just the dates included in this example.

Cognito-forms – Age calculation in Cognito Forms

I am a developer for Cognito Forms

You can do this with the use of two fields. The first field is a Date filed with the label of "Birth Date". This will be the title I use in the calculation in our next field.

The next field we need to add is a Calculation field. You can title this anything you need to and for this example I used "Age" we are then going to use the fallowing calculation in the calculation field.

=DateTime.Today.Year - BirthDate.Year + (DateTime.Today.Month < BirthDate.Month or (DateTime.Today.Month = BirthDate.Month and DateTime.Today.Day < BirthDate.Day) ? -1 : 0)

This will allow a user to input their birth date into the Date field and the users age will be placed as a number onto the form in the Age field.

enter image description here

Best Answer

Related Solutions

Cognito-forms – Calendar calculation in Cognito Forms

Cognito-forms – Age calculation in Cognito Forms

Related Topic