Age field based on date field

This is way over my head. If I copy and paste this into my document (in the properties of the field), will it work?

I changed the name of my Text Field (which contains the date of birth) from a102 to DOB. I created a new Text Field called Test and pasted:

event.value = "";

var dobValue = getField("DOB").value;

if (dobValue!="") {

var dob = util.scand("dd/mm/yyyy", dobValue);

var today = new Date();

// compute years on full year only

var age = today.getFullYear() - dob.getFullYear();

var TodayMMDD = today.getMonth() + today.getDate()

var dobMMDD = dob.getMonth() + dob.getDate();

if( TodayMMDD < dobMMDD) age -= 1;

event.value = age;

}

...into the Format tab under Custom and Custom Format Script. Is that right? It does not appear to have worked.

My mistake. I repasted in Custom Calculation Script and it still did not work. I noticed that in your code, you formatted the date with 2 digits for day, month and 4 digits for year. So I changed my DOB text field to 2 digits for day and month and 4 digits for year. Do those need to be the same?

It still did not work, and then I noticed in your code that you have day first, then month, then year. So I edited the code and put mm/dd/yyy in place of dd/mm/yyyy. I retried and now my new Age text field populates an age when a date of birth is entered into the DOB field. But unfortunately, it was the wrong age! I entered 03/28/1983 into the DOB field and the Age field populated 29, instead of 30. Any thoughts why?

Also, I have 6 DOB fields and need 6 age calculations. What part(s) of the calculation code would I need to rename to have 6 different calculations and for the Age fields to correspond to the proper DOB fields? Thanks.

Okay, so I repasted the new code and now some birthdays work and others don't.

Examples:

03/28/1983 correctly shows age 30.

03/24/1984 correctly shows age 29.

08/30/2008 incorrectly shows age 5. Should be 4.

01/16/2011 incorrectly shows age 1. Should be 2.

Thoughts?

Does anyone know what I can do here? Does anyone know why the ages are wrong?

I believe I have. Here is the script I'm using:

event.value = "";

var dobValue = getField("a104").value;

if (dobValue!="") {

var dob = util.scand("mm/dd/yyyy", dobValue);

var today = new Date();

// compute years on full year only

var age = today.getFullYear() - dob.getFullYear();

var TodayMMDD = today.getMonth() + today.getDate()

var dobMMDD = dob.getMonth() + dob.getDate();

if( TodayMMDD > dobMMDD) age -= 1;

event.value = age;

}

The format of the text field that this is pulling from is mm/dd/yyyy.

I just checked and all seem to be a year off now.

03/28/1983 showing 29, instead of 30. (This is 1 year too YOUNG.)

03/24/1984 showing 28, instead of 29. (This is 1 year too YOUNG.)

08/30/2008 showing 5, instead of 4. (This is 1 year too OLD.)

01/16/2011 showing 1, instead of 2. (This is 1 year too YOUNG.)

Any ideas why it's always off 1 year and why sometimes it's 1 year too old and sometimes it's 1 year too young?

This works. Thank you. I did find one problem which is not the end of the world. I put in 07/26/XXXX and it is 1 year too young. (That is today's date.) Is it one day behind when it comes to calculating on the same day as the birth day?

This fixed the birthday issue. Thank you.

Hey Gilad D, I noticed that this no longer works on the pdf once they become older. It's as if it is calculating the field once a birthday is originally entered and then never calculates it again. Is there a way to have this be dynamic, so that when I open the pdf, it will show the correct age presently?

Here is the code I currently have. What would you change?

event.value = "";

var dobValue = getField("a104").value;

if (dobValue!="") {

    var dob = util.scand("mm/dd/yyyy", dobValue);

    var today = new Date();

    var age = today.getFullYear() - dob.getFullYear() - 1;

    if (today.getMonth()>dob.getMonth()) {

        age++;

    } else if (today.getMonth()==dob.getMonth()) {

        if (today.getDate()>=dob.getDate())

            age++;

    }

    event.value = age;

}

Gilad D, here is what I have in the field. Does this look right? My Date of Birth field is a104 and my age field is a102. This does not seem to work. Yesterday (10/15/2014), I put the Date of Birth as 10/16/2013 and the age field populated a "0." That is correct. When I opened it up today, the age field should have populated a "1," but it did not. This is the problem I'm running into. Thoughts?

this.getField("a102").value = "";

var dobValue = getField("a104").value;

if (dobValue!="") {

    var dob = util.scand("mm/dd/yyyy", dobValue);

    var today = new Date();

    var age = today.getFullYear() - dob.getFullYear() - 1;

    if (today.getMonth()>dob.getMonth()) {

        age++;

    } else if (today.getMonth()==dob.getMonth()) {

        if (today.getDate()>=dob.getDate())

            age++;

    }

    this.getField("a102").value = age;

}

GKaiseril, I want to make sure you understand my dilemma. I need the age field to be dynamic and not static. The age field correctly populates when I enter in the Date of Birth, but the age field never changes, even when a year passes by and the age is now older. Does that make sense?

Yesterday, I did a test and put in a DOB as 10/16/2013, which would mean the age yesterday was "0" and the age today would be "1." The pdf still says "0" today. Thoughts?

GKaiseril, I'm not sure what the JavaScript console is. I can't post a link to the form unfortunately. I wish I could. Here's what happens:

I set the DOB and the age is correct. Once the next DOB happens, the age stays the same. It does not increase by a year, as it should each time the DOB is reached on the calendar. But if I delete the DOB and re-enter the same DOB, the age updates to the correct age. This is what happened with the old code and the new one from Gilad D. What happens on your end when you enter the DOB as tomorrow? Does the age update itself the next day?

//Since you know so little//

Fair enough. Here you go.

Connected Data, Inc.

Check out field a102.

So, did you guys see the form?

Unknown? I thought Transporter was well-known. How do I provide a direct link to the file?

Here you go. Thanks.

Dropbox - delete.pdf

Gilad D, are you understanding the problem? The problem is getting the field to update when a birthday happens. I changed the code like you said and it did not work. I entered a DOB of 10/29/2013 on 10/28/2014. The age correctly populated as 0. But today, it should read 1 and it still reads 0. Thoughts?

Thanks. I would not know how to do that. What is the form using to calculate the date when the DOB is first entered? Wouldn't that value be dynamic? Shouldn't this work without having to make a hidden form field?