Thread: [Solved] Age Calculation
View Single Post
 
Old 10-31-2012, 11:10 AM
lawlaw lawlaw is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Oct 2012
Posts: 12
lawlaw is on a distinguished road
Default

Thanks Macropod. However, I don't believe the code provided who reach my goal, but I could be wrong.

I am an attorney and what I am doing is exporting information from my practice management software (PMS) into Word. In my PMS I have the child's birthdate and that merges into word as a merge field. To automate further, I want the merge document to auto-calculate the child's age based on the mergefield with the birthday in mm/dd/yyyy format. I feel the problem arises because the birthdate comes into word as numbers and slashes as, ex. 01/01/2001, and does not have mm dd yyyy attached to it. So I'm looking for a way to take the raw data "01/01/2001" and have word produce an Age based on that data. See below for an example:

3. Information About the Minor Child(ren) for whom I want the order changed:
Name: «MAT_Child_1_Name»
Birth Date: «MAT_Child_1_DOB»
Age: <age calculates here>


The «MAT_Child_1_DOB» is the merge field from my PMS as "01/01/2001" or whatever the birthdate is.

Is it possible to have the age auto-calculated here?
Reply With Quote