Calculating Difference of Dates in Days
Hello,
I would like to inquire for help. I have built a fillable form in Adobe Acrobat Pro and am trying to calculate the total days left to complete a project. In simplest notation, the formula would read ((ProjectEndDate1)-(TodaysDate))=(DaysLeft1).
This would be done similarly across 10 different projects which share the same form, so the indicator number would change per project, (i.e., 1, 2, 3,....10.).
Other Info: Both fields, (ProjectEndDate1) and (TodaysDate) and standard drop down date fields, where as (DaysLeft1) is a text box formatted as a number, is this correct?
I am unfamiliar with Java Script and its Syntax; would you be able to write a formula for me that would calculate this? Is JavaScript needed or can this formula be calculated in a simpler way?
