cognito-forms
I am trying to work out how the future date displays in the calendar option for future reservation.
At this moment it even shows the past days and years. The calendar should start from the date when a person trying to fill in the Cognito form, like StartDate > DateTime.Today.
How can I get the calendar to show only future dates?
I am a developer for Cognito Forms. Currently we don’t allow for additional users within a single Cognito account. However, this is a feature we are actively working on and plan to add in an upcoming release, and you can follow its progress on our idea board. In the interim, you can set each specific form to send its entry notifications to one or more email address. This is under the Form Settings menu, and you can check the box to include entry details as well. This would allow other people in your organization to review the entries without having to log in. Hopefully this is a good workaround for your organization until we add multi-user support, but if there are additional features you’d like to see, you can use our request form.
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
Best Answer
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.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:
And this is how the Start Date appears on the form, with the days before today disabled:
And similarly for the End Date, with both minimum and maximum date restrictions based on the Start Date.
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.
Please note that range validation applies to Date, Number and Currency fields, not just the dates included in this example.