Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Age Calculation

Avatar

01-07-2008

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?

Replies

Avatar

Avatar
Boost 5
Level 7
gkaiseril
Level 7

Likes

13 likes

Total Posts

456 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 7
gkaiseril
Level 7

Likes

13 likes

Total Posts

456 posts

Correct Reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
gkaiseril
Level 7

01-07-2008

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

Avatar

04-01-2009

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.