cognito-forms
I need to show a date inside a form that is 3 business days from today. If today's date is Monday, March 21st, the calculated date would be Thursday, March 24th. I know that I can do that by using =DateTime.today.AddDays(3). However, if today's date is Thursday, March 24th, the calculated date would be Tuesday, March 29th, which is actually AddDays(5). How do I ignore Saturday and Sunday?
Bonus points if I can ignore holidays as well.
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.
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.
Best Answer
Date Calculations in Cognito Forms are extremely powerful and can handle most types of date calculations with enough effort.
The following answer assumes you have an
OrderDatefield that represents today's date, and are calculating aDeliveryDatethat is three business days in the future.You can calculate three business days from the now using this calculation:
Delivery Date
=OrderDate.AddDays(if OrderDate.DayOfWeek = "Monday" or OrderDate.DayOfWeek = "Tuesday" then 3 else if OrderDate.DayOfWeek = "Sunday" then 4 else 5)For bonus points you can refine the delivery date to add an extra day for specific holidays:
Holiday Delivery Date
=DeliveryDate.AddDays(if OrderDate <= "7/4/2016" and DeliveryDate >= "7/4/2016" then 1 else if OrderDate <= "11/24/2016" and DeliveryDate >= "11/24/2016" then 1 else 0)Here is a shared template demonstrating how this works: https://www.cognitoforms.com/templates/shared/CognitoSupport/SkipWeekdaysHolidays