calculatorcognito-forms
I will have our users input "today's" date on a form, and I want the next field to auto-populate to the next Friday:
So if the submission date is 9/25/2017, the calculated field would be 9/29/2017.
Or if the submission date is 9/29/2017, the calculated field would be 9/29/2017.
Is there a way to use the default date in a date field, or a calculation field to make this happen?
First off, I am a developer for Cognito Forms. This is a feature we are adding in the next release, which is currently in testing. Here is an example of the feature on the Form Settings Menu.
We will be sending out an email to all Cognito users when the new features become available.
I am a developer for Cognito Forms.
You are very close to getting the calculation to work, AddDays takes an integer value and the value and what you were generating is a decimal value. You will need to add a little extra code to your Due Date calculation to get it running correctly.
=DateTime.Today.AddDays(Int32(CalculatedTime))
One other change I would make to your calculation in the CalculatedTime field would be to remove the quotation marks (") from around the numebrs, so your calculation looks like this:
=ProjectType = "Flyer: Up to 30 Products" ? 7 : ProjectType = "Flyer: Up to 60 Products" ? 12 : ProjectType = "Flyer: 60+ Products" ? 18 : 7
Best Answer
I'm a developer with Cognito Forms.
You can use the following calculation in a second Date field, that is targeting another date field. By targeting the first Date will be used to enter in the current date.
You can then set the second Date field that is using this calculation, to hidden or internal. Then create a calculation field that targets the second date field and display's the value.
You can see this in action in a template that we have created. This will let you copy a working template into your own Organization.
https://www.cognitoforms.com/templates/shared/CognitoFormsTemplateDemo/NextFriday