Acrobat User Community Forums

shawnash · 2010-02-08 17:07:59

ANSWERED

Hello,

I have a field called HireDt that is formatted as date and mm/dd/yyyy. I want to compare HireDt with today's date and come up with YrsSvc calculated field with only the full years between.

Any help would be appreciated.

Thanks, Shawn

try67 · 2010-02-08 18:33:16

There are plenty of tutorials on how to work with Date objects on this website. I suggest you search for them. But basically, you need to do something like this:

Code:

date = util.scand("mm/dd/yyyy",dateAsString);
difference_in_years = date.getFullYear() - (new Date().getFullYear());

(edit: this will just show the difference in whole years, if you want to take the actual day into account it needs to be tweaked a bit)

Last edited by try67 (2010-02-08 18:35:07)

shawnash · 2010-02-08 19:46:57

Ok, thanks for the response and I will try it. But, how do you get today's date?

try67 · 2010-02-09 03:08:32

When you create a new Date object it automatically has the current date and time.

shawnash · 2010-02-09 10:19:27

Thank you - this almost works. I know I am probably missing something really simple here, but I entered 03/10/2000 into my HireDt field and my YrsSvc field should have come up to 9 years from today's date because we have not reached March 10th yet. But it is rounding up and I am getting 10 years instead.

This is my code.
var Hire = this.getField('HireDt').value;
date = util.scand("mm/dd/yyyy",Hire);
difference_in_years = (new Date().getFullYear()) - date.getFullYear();
event.value = difference_in_years;

Any help is appreciated.
Thanks, Shawn

try67 · 2010-02-09 11:47:26

ACCEPTED ANSWER

Well, like I said, the other script was not perfect, because it didn't take into account the day of the year.
This version does:

Code:

var Hire = this.getField('HireDt').value;
date = util.scand("mm/dd/yyyy",Hire);
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;

shawnash · 2010-02-09 12:43:07

Thank you so much, that worked perfectly! :)

Member Log in

Returning members

Not a member yet?

Step 1: Check us out

Step 2: Sign up for a free account

Step 3: Start participating

Acrobat User Community Forums

#1 2010-02-08 17:07:59

Years between 2 dates Calculation

#2 2010-02-08 18:33:16

Re: Years between 2 dates Calculation

Code:

#3 2010-02-08 19:46:57

Re: Years between 2 dates Calculation

#4 2010-02-09 03:08:32

Re: Years between 2 dates Calculation

#5 2010-02-09 10:19:27

Re: Years between 2 dates Calculation

#6 2010-02-09 11:47:26

Re: Years between 2 dates Calculation

Code:

#7 2010-02-09 12:43:07

Re: Years between 2 dates Calculation

Board footer