Need to Create a Custom Calculation Script

[defaultp9ni07ctugl6]

OK so I created a form and I'm stuck in the calculations. I have a start date, an end date and a dollar amount. I need to calculate a dollar amount based on the number of days.

Example:

Start Date  is 8/1/21

End Date is 8/4/21

Dollar Amount is $200

So the easy way to explain is 8/1/21 through 8/4/21 is 3 days... 3 days * $200 is $600

The dates and dollar amount will be entered by the employee and the result of $600 will automatically be calculted.

How can I accomplish this?

[ls_rbls]

You can accomplish this by creating your own script with Acrobat JavaScript. Have you tried doing your own script?

If so, would you mind sharing it?

In the meanwhile, see this tutorial from ACP Thom Parker on how to calculate the total number of days based on two dates: 

• Working with date and time in Acrobat JavaScript - PART 1 
• Working with date and time in Acrobat JavaScript - PART 2 
• Working with date and time in Acrobat JavaScript - PART 3 

Check the sections that explain how to calculatethe difference in  total number of days. Then add to your script a conditional statement to calculate the total number of days obtained from the two dates and multiply by the desired dollar anount or by obtaining the value from another field object in your PDF form.

[try67]

Why is the result 3, in this case? Does it not include the first day? What should happen if both dates are the same?

[defaultp9ni07ctugl6]

The dates will never be the same in this specific document.

8/1 - 8/2 is one day

8/1 - 8/3 is two days

8/1 - 8/4 is three days

etc etc etc

i need the formula result to calculate the number of days between the dates * $200 per day

[try67]

OK. However, without the year this is not going to work properly, unless you make assumptions about the length of the period.

[try67]

Sorry, I see you did include the year in your original post...

[defaultp9ni07ctugl6]

That was just a quick example...the form has the year. They select from a calendar 

[try67]

You can use this code as the custom calcualtion script of the amount field:

var startDateString = this.getField("Start Date").valueAsString;
var endDateString = this.getField("End Date").valueAsString;
if (startDateString=="" || endDateString=="") event.value = "";
else {
	var d1 = util.scand("m/d/yy", startDateString);
	var d2 = util.scand("m/d/yy", endDateString);
	var diffInDays = Math.round((d2.getTime()-d1.getTime())/86400000);
	event.value = diffInDays*200;
}