self-updating year reference brain teaser

[Guest]

Instead of typing i.e. Joe has 5 years experience, you can embed a
calculation field in that sentence that will update itself each year without
further 'date maintenance'.

If you just use, for example, the calculation formula, { = { DATE \@ "yyyy"
} - 2002 } for the calc field, you always get a single digit number for
under ten years. But this conflicts with the AP Stylebook and Chicago
Manual, which state that years 1-9 should be written out rather than using
digits.

I wonder if the above calculation field can be modified to parse the date
and return a written number for years 1 thru 9, but digits for all years
above that number...or would such a complex calculation be beyond Word's
Field capabilities?

 

[Stefan Blom]

Try this:

{ IF { = { DATE \@ "yyyy" } - 2002 } > 9 "{ = { DATE \@ "yyyy" } -
2002 }" "{ = { DATE \@ "yyyy" } - 2002 \* CardText }" }


--
Stefan Blom
Microsoft Word MVP


in message
news:[email protected]...

 

[Guest]

Wow! that's quite a mouthful! But when I very carefully reconstruct your
formula, and press Alt-9, the field disappears and produces no result.
(Another Alt-9 brings the formula back into view, tho) I assume it worked
for you or you wouldn't have posted it, ...right?

 

[Herb Tyson [MVP]]

You need to press F9 to update the field. Alt+F9 just toggles the display
without updating it. Here, when I construct the field as shown and press F9,
it displays "five".

 

[Guest]

Of course-that does it! Thanks!

You need to press F9 to update the field. Alt+F9 just toggles the display
without updating it. Here, when I construct the field as shown and press F9,
it displays "five".

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com

 

[Stefan Blom]

I'm glad you got it sorted.

--
Stefan Blom
Microsoft Word MVP


in message