Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-31-2012, 11:10 AM
lawlaw lawlaw is offline Age Calculation Windows 7 64bit Age Calculation Office 2007
Novice
Age Calculation
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel calculation help Purge07 Excel 4 05-20-2016 07:46 PM
Help with a sum calculation please. ballst Excel 4 06-04-2015 11:40 AM
Formula Calculation medavidcook Excel 2 03-21-2015 03:47 AM
Please help with age calculation!!! Microsoft Idiot Word 4 10-29-2012 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft