Age Calculation

[Former Community Member]

I have created a form and would like to have a field that returns the age of a person as of July 31, 2008 passed upon their entry in the Date of Birth Field. I have researched the internet and used the Date2Num formula, but can not get it to work, does anyone have any suggestion on the formula I should use?

[gkaiseril]

You have to match the optional format string to the data being passed.

[Former Community Member]

Hi:



I was wondering the same thing as Jennifer, but my question is more along the lines of this:

_______________

| |

| Date of Birth |

|_______________|

dateField1



_______________

| |

| Display age |

|_______________|

dispAge1



Where dateField1, the user of the form, enters in their date of birth and then once the cursor leaves the date field, if the age is less than 10 years old, dispAge1 display's "Under 10!" in red. If the age is over 79 years old, it display's "Over 79!" in red. And if the age is between 10 and 79, then it should display, "Qualified", along with the age and in Green.



_______________

| |

| Qualified 73 |

|_______________|

dispAge1



On null, incomplete or error, the field remains blant and the user is given an error message saying, "Invalid Entry".



Is this possible in an Acrobat 9 form, and what do I need to do to get it to work like that? Thanks.