Skip to main content
K
Killing-Me-Softly
Participant
April 28, 2024
Answered

Custom Calculation Scripts to PDF calculate Start date from total days and result in end date

  • April 28, 2024
  • 3 replies
  • 976 views

I've looked all over the community forums and tried a few things that people suggested 

I am having trouble finding the right script to calculate the start date and count the total days the result shows in the end date. 
Vacation PDF Formate

For Example

Vacation Start date = 01-04-2024 ="AnVac1"

Vacation Total Days = 30 days = "Total Days"

Vacation End Date = 30-04-2024="AnVac2"

 

I need result in Vacation End Date with script to calulate  

I never have to work with scripts - just need some help this one time. 

This topic has been closed for replies.
Correct answer Nesa Nurani

Try this as 'Custom calculation script' of "AnVac2" field:

var f1 = this.getField("AnVac1").valueAsString;
var f2 = this.getField("Total Days").valueAsString;

if (f1 && f2) {
 var date = util.scand("dd-mm-yyyy", f1);
 date.setDate(date.getDate() + (Number(f2) - 1));
 event.value = util.printd("dd-mm-yyyy", date);} 
else {
 event.value = "";}

3 replies

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
April 29, 2024

Try this as 'Custom calculation script' of "AnVac2" field:

var f1 = this.getField("AnVac1").valueAsString;
var f2 = this.getField("Total Days").valueAsString;

if (f1 && f2) {
 var date = util.scand("dd-mm-yyyy", f1);
 date.setDate(date.getDate() + (Number(f2) - 1));
 event.value = util.printd("dd-mm-yyyy", date);} 
else {
 event.value = "";}
    K
    Killing-Me-SoftlyAuthor
    Participant
    April 30, 2024

    Thanks a lot, Nessa Noorani for such accurate and remarkable support for resolving new people's queries.

     

    try67
    Community Expert
    try67Community Expert
    Community Expert
    April 28, 2024

    This type of question has been asked (and answered) on these forums many times in the past. Try searching around and you're bound to find some answers, including the code needed to do it.

    Alternatively, read these tutorials about working with Time and Date objects in Acrobat JS:

    https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript

    https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript-part-2

    https://acrobatusers.com/tutorials/working-date-and-time-acrobat-javascript-part-3-3

     

    Or, if you just want a simple solution to your problem, you can use this (paid-for) tool I've developed that allows you to set it up very easily and quickly, without having to write any code:

    https://www.try67.com/tool/acrobat-apply-automatic-date-calculation

     

      K
      Killing-Me-SoftlyAuthor
      Participant
      April 29, 2024

      TRY67 I saw many community this same message/thread.

      Abambo
      Community Expert
      AbamboCommunity Expert
      Community Expert
      April 28, 2024

      Are you looking for the total days, or the total working days?


      I'm sure that it is possible to do that in Acrobat, but I'm not persuaded that Acrobat is the best application for this.

      ABAMBO | Hard- and Software Engineer | Photographer
      K
      Killing-Me-SoftlyAuthor
      Participant
      April 28, 2024

      Yes result date is calculated after the total days

       

      Hope someone help to solve this

       

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices