PC Review


Reply
Thread Tools Rate Thread

annually incrementing number?

 
 
=?Utf-8?B?Qm9iVw==?=
Guest
Posts: n/a
 
      7th Mar 2006
Is it possible to format an annually incrementing number in a Word.doc so
that, ie, "Joe has 15 years of experience" automatically updates (increments)
to "Joe has 16 years of experience", one year after a specified date. This
would allow years of service to be embedded in resumes maintenance-free, as
well as enable corp comm groups to keep their company history texts up to
date, and a host of other applications. Same goes for monthly, bi-annual,
semi-monthly, etc.
 
Reply With Quote
 
 
 
 
Charles Kenyon
Guest
Posts: n/a
 
      7th Mar 2006
Is it possible? Yes. Would I want to do it? No.

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to
utilities to create the fields and an explanation of different macros that
can be used instead of fields. It also has a link to
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document
with various fields already created.

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"BobW" <(E-Mail Removed)> wrote in message
news:C9A059AC-3054-4343-A2C6-(E-Mail Removed)...
> Is it possible to format an annually incrementing number in a Word.doc so
> that, ie, "Joe has 15 years of experience" automatically updates
> (increments)
> to "Joe has 16 years of experience", one year after a specified date.
> This
> would allow years of service to be embedded in resumes maintenance-free,
> as
> well as enable corp comm groups to keep their company history texts up to
> date, and a host of other applications. Same goes for monthly, bi-annual,
> semi-monthly, etc.



 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      7th Mar 2006
You can get a rough approximation with a calculated field such as { = { DATE
\@ yyyy } - 1992 }. This will roll over on January 1, obviously, rather than
the actual anniversary date. If Word could handle serial dates (number of
days since January 1, 1900) or even days of the year 1-365, more precision
would be possible.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"BobW" <(E-Mail Removed)> wrote in message
news:C9A059AC-3054-4343-A2C6-(E-Mail Removed)...
> Is it possible to format an annually incrementing number in a Word.doc so
> that, ie, "Joe has 15 years of experience" automatically updates

(increments)
> to "Joe has 16 years of experience", one year after a specified date.

This
> would allow years of service to be embedded in resumes maintenance-free,

as
> well as enable corp comm groups to keep their company history texts up to
> date, and a host of other applications. Same goes for monthly, bi-annual,
> semi-monthly, etc.


 
Reply With Quote
 
=?Utf-8?B?Qm9iVw==?=
Guest
Posts: n/a
 
      8th Mar 2006
I can see where Charles would not want to do this; any discrepancies with a
user's date/time settings, or a document control system server's date/time
settings, could cause a real mess wherever these fields were embedded in
documents.

"Suzanne S. Barnhill" wrote:

> You can get a rough approximation with a calculated field such as { = { DATE
> \@ yyyy } - 1992 }. This will roll over on January 1, obviously, rather than
> the actual anniversary date. If Word could handle serial dates (number of
> days since January 1, 1900) or even days of the year 1-365, more precision
> would be possible.
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
> Word MVP FAQ site: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so
> all may benefit.
>
> "BobW" <(E-Mail Removed)> wrote in message
> news:C9A059AC-3054-4343-A2C6-(E-Mail Removed)...
> > Is it possible to format an annually incrementing number in a Word.doc so
> > that, ie, "Joe has 15 years of experience" automatically updates

> (increments)
> > to "Joe has 16 years of experience", one year after a specified date.

> This
> > would allow years of service to be embedded in resumes maintenance-free,

> as
> > well as enable corp comm groups to keep their company history texts up to
> > date, and a host of other applications. Same goes for monthly, bi-annual,
> > semi-monthly, etc.

>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Incrementing a number for each row DontKnow Microsoft Access Form Coding 5 5th Dec 2008 12:02 AM
Order Number Unique Number Auto Incrementing Louise54 Microsoft Access Database Table Design 8 28th Apr 2008 05:33 PM
Incrementing number =?Utf-8?B?Um9zZW1hcnk=?= Microsoft Access Form Coding 1 10th Feb 2005 12:53 PM
Incrementing number =?Utf-8?B?c2FnZXNlYXJjaGVy?= Microsoft Word Document Management 1 7th Jun 2004 04:08 AM
Incrementing Number Daniel Microsoft Access 2 19th Aug 2003 10:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:56 AM.