- KWTCBOISEAsked on November 11, 2016 at 07:42 PM
Is there a way to have a field automatically calculate a date if give the start date and how many calendar days por business days need to be figured in?
-Contract start date is 11/14/16
-We have 3 business days from contract date to complete a task.
How do I set up a field that will automatically calculate the correct date of 11/17/16. (Doesn't include the start date of the contract.)
- JotForm SupportMike_GAnswered on November 11, 2016 at 07:45 PM
Yes, it would be possible to get the Complete Date (three days after) base on the current date or today's date.
Below is a sample form. (I didn't hide any of the fields just to show how it works.)
In the form above, you'll see that there is a field called "Start date(Current Date)". That field has a default value in it which is the current date.
There is also another date field which is the "Complete Task Date ( 3 days after Start Date)" it doesn't have a default date. It is where the output will show.
Then, there's the "Form Calculation" widget, where we set the calculation.
Start date(Current Date) + 3
The Calculation field will add 3 days to the Date field (in numeric format).
Then, we will create a condition using conditional logic (Update / Calculate field) that will pass the value of the Calculation field to the "Complete Task Date ( 3 days after Start Date)" where it will automatically be converted again to date format showing the correct date.
I hope this helps. Please feel free to contact us anytime if you have other questions regarding this.