Aside from your above response and out of curiosity, when performing calculations or manipulations on a "Date/Time" field, what does Adobe assume for the format of the "Date/Time" field?
Yesterday while trying to solve my issue, I discovered that the "Date/Time" field format appeared to be different the Display, Edit, Validation and Data formats. It appeared to be YYYY-MM-DD, which is different than my assigned Display, Edit, Validation and Data formats.
>>The default would be the format that your machine has set.
That's interesting. So the users' machines are very likely different than mine. So there's no way of knowing in advance. That would seem to make the routine suggested by Jared Langdon (see my top post in this thread) somewhat troublesome? If users' machines are set differently than his, then his routine wouldn't work?
I learned two important items with this task:
1) I need to somehow specify (as done by Stephen) the format of the date numbers before I use them;
2) Rather than using the Calculation Event on the Age, I should instead use Exit Event on the Date-of-Birth field.
I found a problem with the script provided by SL Walker.
age = Round((Date2Num(dob.formattedValue,"MM-DD-YYYY")-Date())/365.25)*-1
when I enter a dob of 03/01/1980 then age = 29, and when I enter a dob of 04/01/1980 then age = 29, but that is incorrect b/c their bday has not occured for the present year so the age is actually 28 until 04/01/1980.
I do not know the solution to fix this but if anyone else does I would appreciate the help!