Calculate the difference in years between two dates

Question

HiI have 4 fields named year1, year2, year3, year4 respectively.I want to calculate the difference in years with respect to the dates entered respectively in "HIRES1", "HIRES2", ASSUNCTION3, ASSUNCTION4.In the calculation script of each field I have inserted this formulavar s1 = this.getField("HIRES1").value;date = util.scand("mm/dd/yyyy",s1);now = new Date();difference_in_years = (now.getFullYear()) - date. getFullYear();if (now.getMonth()<date.getMonth()) {difference_in_years--;} else if ((now.getMonth()==date.getMonth()) && (now.getDate()<date .getDate())) {difference_in_years--;}event.value = difference_in_years;The formula works to calculate the years starting from the date inserted in "ASSUNCTION1", while for the other fields the console gives me this error messageTypeError: date is null1:Console:ExecundefinedAnyone who can help me solve this problem?Thank you

Thom Parker · Answer

First, when you post code, please format it so it can be read.

The "util.scand" function returns null when it is given a date string that does not match the format provided. So, the date fields that are showing this error, must not be formatted correctly.

Add a "console.println()" statement to the code to display the input date string.

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