Hi!
I must state that I am by no means trained in any form of programming/coding. What I have learned over the past week, I have done by finding information on the internet.

Here is what I am trying to achieve:
1. I am currently developing a form and I want the age to be calculated based on the current date and the DOB entered by the individual completing the form. The code I entered keeps on returning the age of the person rounded up. Ex: I entered April 8, 1981 as the DOB and the age returned is 33 instead of 32 (the person will only be 33 on April 8th of this year). I have included the Word document that I have been working with. Someone told me it might have something to do with updating fields (this means nothing to me J)
2. If the individual’s age is below 1 year of age, I would like the code to reflect the age in months. That being said the output would be “years” if they are over the age of 1, “year” if they are 1 year old, months if they are 2 to 11 months of age and “month” if they are 1 month old and “weeks” if they are only a few weeks old.
Any help would be appreciated. I have been working on this for a few days and I have no idea what I am doing J. I feel like the code in my word document should function, but I keep on getting a total that is off by 1.



Thank you!

Attached Files

coding_test.docx (21.8 KB, 55 views)

I suspect you can find everything you need in the document attached to this thread:
Microsoft Word Date Calculation Tutorial

There are plenty of sample fields and instructions.

Cross-posted and answered before posting here, at: http://answers.microsoft.com/en-us/o...4-ecddc708f64b
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Regarding the Tutorial, it does not really help me since I will not require all three (years, months, days) listed at once, I will require years for someone who is 1 year or older, months for an infant that is 4 weeks old to 11 months old and days for an infant that is below 1 month of age...

Yes, my friend posted that on my behalf, however, it does not solve the problem I am experiencing. I used "F9" to update the fields, and still I do not get the correct age. This is why I included the Word document to see if anyone could look at it and let me know what the issue is...

Thanks anyways though...

The tutorial will give you the answer. You do not have to display all of the results.

Xaand,

There are some fundamental problems with your attached document:
1. The field code you are using is NOT the same as the textual representation of it that appear in the document and that you have posted online. A glaring difference is that you've changed some of the switches in the field code to something quite incompatible with the calculations;
2. You have inserted the formfields inside content controls!!! Formfields and content controls are not meant to be used in the same document, let alone one inside the other.
Fix those issues and the calculation field will work correctly.

As for "it might have something to do with updating fields", the formfield 'calculate on exit property takes care of that. If you use content controls, though, a different approach would be required (e.g. a macro or Ctrl-A, F9).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi!

I just wanted to thank you for all of the information you have provided me with. The tutorial I was referred to by Charles Kenyon and the "fundamental problems" pointed out by macropod, as well as searching on various forums, have allowed me develop a functional sheet! Yay!

I’ve never done anything like this before, so it was great to hear from people who had experience with these types of issues and who were willing to assist me.

Thanks again!

You are welcome. We all started as beginners.

Hi!


Like yourself, I too am a "newbie" to all this!


" field code" "textual representation" "switches in the field code" "inserted the formfields inside content controls" . . .
OMG! Way above my pay grade! LOL!


Could you share the exact coding your arrived at, in the context of an actual document you created?


Many thanks!

Look to the tutorial by Paul Edstein (macropod) that was linked above.
Microsoft Word Date Calculation Tutorial
It has ready-to go field coding, but read the introductory material.

See also the cross-posted question.
Redirecting

Additional resource: Dealing with Fields in Microsoft Word

You are not asking about basic stuff. It is time to dig in and learn some. That is what the tutorial is for.

• Fields in Word are dynamic bits in a document that can change based on other information without macros. In this case, a complex field changes its results based on a date input elsewhere and marked as a bookmark.
• Fields have code that tells Word which field you are using and what you want it to do. The code and the switches may be specific to the field. There are online references for each field. List of field codes in Word
• The textual representation is, I suspect, someone's typing what a field code looks like here - in text. Field codes are not text, exactly, in that the { } braces must be inserted by Word, not typed.
• Field results are what you see on the screen when a field is updated and not displayed as code.

[Legacy] Formfields and Content Controls are two ways of getting information from a user. They should not both be used in the same document/template.

• Making Forms with Microsoft Word