View Single Post
  #5   Report Post  
Posted to microsoft.public.word.docmanagement
macropod
 
Posts: n/a
Default How to calculate Future Dates?

My Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902
(which Charles referred you to) has a *relatively* simple field for
calculating month-based offsets. Best of all, all you may need to do is to
copy whichever one best suits your needs and change the 'delay' variable and
'DATE' to 'SAVEDATE'. All the instructions are in the file.

Cheers

"designgeek" wrote in message
...
Thanks Charles .. I didn't realise it was going to be THAT complex, so I'm
not going to do this. I'll keep trying to play around but I've had no

success
even just copying and pasting previous auto text codes. I can't seem to
modify them to what I want and don't understand how in the code is

specifies
delay by X number of days, months or years!

All I want is { SAVEDATE + 22 months } kind of thing!!

is there anyway in which to do the SAVEDATE - 2 month + 2 years kind of

thing?

I'm going to add learning about 'field codes' to my training plan but any
help you can offer for right now I'd be very grateful.

Thanks
Cath.

"Charles Kenyon" wrote:

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. Another resource is
http://www.gmayor.com/insert_a_date_...than_today.htm.

--
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.

"designgeek" wrote in message
...
I already have word automatically generating the 'last saved date' of

the
document, which I call the 'effective date'. This is always in the

same
location and never moves.

From this I would like for word to calculate, automatically, two

future
dates. This would remove the need for people to manually enter those

dates
and as such make mistakes.

I would like to be able to take this effective date and generate two
future
dates: Review date = (effective date + 22 months) and also Expires

date =
(effective date + 24 months)

an example of this is:

Effective Date: 5 April 2006
Review Date: 5 February 2008
Expiry Date: 5 April 2008

Is there anyway to 'reference' another date and create to future dates
from
this? I've done this within excel and now need the same functionality

but
for
word..

Help!