How to Calculate a PDF Form End Date One Year After a Start Date
Question details
The user wants to configure a fillable PDF form so that when a start date is entered, a termination date field automatically calculates and displays a date exactly one year later.
- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Building a dynamic fillable PDF contract or agreement where a one-year term needs to be computed without manual data entry.
- Observed behavior
- The goal is to establish a 'Termination Date' field that automatically updates based on the input from the 'Start Date' field using JavaScript.
Ensure both your start date and end date fields exist in your PDF form, note down the exact field name used for the start date, and decide on a consistent date format (e.g., mm/dd/yyyy).
Use Custom Calculation Script in Adobe Acrobat
Apply a simple JavaScript snippet using util.scand and util.printd within the termination date field's calculation properties.
By using the custom calculation script feature, you can dynamically read the start date, add exactly one year to it, and output the result in your desired date format. This requires basic JavaScript but perfectly solves the automated calculation requirement.
Right-click the 'Termination Date' field in your PDF form and select 'Properties' from the context menu.
Navigate to the 'Calculate' tab in the Properties window and choose the 'Custom calculation script' option.
Click the 'Edit' button and paste the following JavaScript code: var strDate = this.getField('TodayDate').value; if ((strDate != '') && (dtCur = util.scand('mm/dd/yyyy', strDate))) { dtCur.setFullYear(dtCur.getFullYear() + 1); event.value = util.printd('mm/dd/yyyy', dtCur); }
In the pasted script, replace 'TodayDate' with the exact name of your start date field. If your form uses a different date format, change 'mm/dd/yyyy' to match your specific format in both the util.scand and util.printd functions.
Click 'OK' to save the script, then close the Properties window. Test the form by typing a date into the start date field and pressing Enter or clicking away to see the termination date populate automatically.
Easily Create and Manage Fillable PDF Forms with WPS Office
WPS Office offers robust PDF editing tools, allowing you to quickly design interactive forms, insert text fields, manage date formats, and handle form properties without hassle.
- 1. Open Your PDF: Launch WPS Office and open your PDF document to begin editing.
- 2. Access Form Tools: Navigate to the 'Form' tab on the top ribbon to access all interactive form creation tools.
- 3. Insert Form Fields: Select 'Text Field' or 'Date Field' and click on the document area where you want users to enter their information.
- 4. Customize Properties: Double-click the inserted field to open its Properties window, where you can define formatting rules and behaviors.
Frequently Asked Questions
How can I change the calculation to add exactly 30 days instead of a year?
You can modify the script by replacing the 'setFullYear' line with: dtCur.setDate(dtCur.getDate() + 30); This will accurately add 30 days to your start date.
Why isn't my termination date updating when I change the start date?
This usually happens because the field name in the script does not exactly match the field name in the form. Double-check your spelling and capitalization inside the this.getField('YourFieldName') section.
Can I use a date format like dd-mm-yyyy?
Yes. You simply need to replace 'mm/dd/yyyy' with 'dd-mm-yyyy' in both the util.scand and util.printd functions in your custom calculation script. Make sure your users input the date using this exact format.
Will these custom calculation scripts work in browser-based PDF viewers?
Advanced JavaScript calculations in PDFs generally require a dedicated desktop PDF reader like Adobe Acrobat or WPS Office. Standard web browsers may not fully support all PDF calculation scripts.
