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]

Use script in the field where you enter event date, and replace "Event-Date" with field name in which you want to show date that is 90 days less.

[Gary312761781awx]

It is calculating, but what I need is for the calculations to begin after someone selects a date in "Text1"

It calculates from Today's date rather than a date value entered by the person filling the form - it actually needs to calculate five dates

Here is the complete script I used

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

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

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

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

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

[Nesa Nurani]

Use this script in field where you input date:

function setDateField(fieldName, daysOffset) {
 var date = util.scand("mm/dd/yyyy", event.value);
 if(event.value == "") {
  this.getField(fieldName).value = "";} 
 else {
  date.setDate(date.getDate() - daysOffset);
  this.getField(fieldName).value = util.printd("mm/dd/yyyy", date);}}

setDateField("Text2", 90);
setDateField("Text3", 30);
setDateField("Text4", 30);
setDateField("Text5", 14);
setDateField("Text6", 7);

[Gary312761781awx]

Thanks for the much simpler code, it still not triggering through the date input in the top text box. As soon as I paste in the code, it calculates all the dates based on today's date. How do I clear and reset the form, maybe that is the issue. I have attached a jpg to show what it is doing. 

[Nesa Nurani]

Do you have other scripts that you forgot to remove?

Use script as 'Validate'.

Share the file, photo doesn't help us.

[Muzaffar36391519kfc0]

Hi

how to add this formula in PDF 

=IF(D23="","",(EDATE(D23,1)-1))