Javascript help

Forum|Forum|5 years ago
September 21, 2020
2 replies
867 views

I have 2 date fields in my form. I am trying to create a third "deadline" field that calculates and displays the deadline which is 90 days from the earlier of the 2 dates. How would I do this using javascript?

Acrobat SDK and JavaScript

This topic has been closed for replies.

Thom Parker

Community Expert

Here's the calculation for the deadline field

var oDate1 = util.scand("mmmm d, yyyy", this.getField("Date1")); 
var oDate2 = util.scand("mmmm d, yyyy", this.getField("Date2"));
var oStart = (oDate1<oDate2)?oDate1:oDate2;
oStart.setDate(oStart.getDate()+60);
event.value = util.printd("mmm d, yyyy",oStart);

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

K

kiki1986

Known Participant

Hi, Thom, I was trying to use this code but whatever I put in first 2 fields it shows only result counting from todays date.

try67

Community Expert

Change the first two lines to:

var oDate1 = util.scand("mmmm d, yyyy", this.getField("Date1").valueAsString);
var oDate2 = util.scand("mmmm d, yyyy", this.getField("Date2").valueAsString);

However, this will still mean that if a field is empty it will be treated like it's today's date. If you don't want that you should let us know what you do want to happen if either (or both) of those fields are empty.

ls_rbls

Community Expert

Basically you can use the script below as a custom calculation script for the "deadline" field:

var s = this.getField("myDateField").valueAsString;  

    var d = util.scand("mmmm d, yyyy", s);  
    d.setDate(d.getDate()+90);  
    event.value = util.printd("mmmm d, yyyy", d);

I am not sure if you you want to run a validation script or similar to determine which of the two datefields has the earliest date. And based on that , then execute the script above. Otherwise the script above should work fine using just one of the date fields as the start date.

try67

Community Expert

That's only part of what they asked for... The first part is to compare the two dates and determine which is the earlier one, and then use that as the basis for the deadline calculation.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded