Calculated Date Field (14+ days from date entered in another field)

[defaultc106a0jig1x3]

Fisrt off, I have spent several hours searching and trying different answers but nothing seems to work for this seemingly simple request.

I have two form fields, one is a date field (mm/dd/yyyy) the user will select the date for, and the other is a calculated date field that needs to add 14 days (same format) to the date the user selects. 

There have been some very complicated formulas I have tried and some very simple ones (Datefield1+14). I would think this could be done as a "Simplified Field Notation", however I cannot seem to find the formula to accomplish this...

[Nesa Nurani · Accepted solution]

As "Custom calculation script" of field where you select date use this.

var date = util.scand("mm/dd/yyyy", event.value);
if(event.value == "")
this.getField("Text1").value = "";
else {
date.setDate(date.getDate() +14);
this.getField("Text1").value = util.printd("mm/dd/yyyy", date);}

Change "Text1" to the name of the field where you want to add +14.

[BarlaeDC · Accepted solution]

Hi,

Just 2 cents on the above answer, I would use a "custom validation script", my reason for this is that a custom validation script is only called when the field changes, whereas a custom calculation script is called when any field changes and in this instance we only need the script to run when the actual value of field changes.

Malcolm

[defaultc106a0jig1x3]

I tried it as both custom validation and custom calculation and it does nothing... 

[defaultc106a0jig1x3]

Annnnd I know why... I was putting it in the field that I want to be automatically updated and pointing it to the field the user enters, not the other way around. This works! Thank you!

[ANNE5FF0]

I used this code and it works perfectly. How can I use this same script, but exclude Sundays?

[BarlaeDC]

Hi,

What do you mean "exclude Sundays"?

Do you mean if the calculated date is a Sunday, they make it the Monday?

OR

If there is a Sunday passed during the calculcation add another day?

[try67]

Just add two extra days... If you add 14 days, then there must be 2 Sundays within that period, no matter what.

[Farshad Chowdhury]

If I need two text fields to display, for example, "Text1 for 14 days and Text2 for 30 days, is it possible??

[BarlaeDC]

Hi,

Just duplicate the dates lines and change the 14 to 30 and change the name of date to secondDate or date2 or some other name.