Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
designgeek
 
Posts: n/a
Default How to calculate Future Dates?

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!
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Charles Kenyon
 
Posts: n/a
Default How to calculate Future Dates?

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!



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
designgeek
 
Posts: n/a
Default How to calculate Future Dates?

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!




  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Charles Kenyon
 
Posts: n/a
Default How to calculate Future Dates?

Look at the articles. Download the sample page. The formula on my page is
for number of days. I'm sorry it is complex, but it is. I am not going to do
it for you, but the page you can download has a number of examples that you
should be able to adjust to get what you want.
--
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
...
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!






  #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!






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate the number of days between two dates? UNI-SOURCE User Mailmerge 1 January 31st 06 03:04 PM
How do I get form fields to calculate in Word? Mystified Mike Microsoft Word Help 1 December 18th 05 04:13 AM
how to calculate the number of days between 2 dates in msword joe17 Microsoft Word Help 1 October 28th 05 06:22 PM
Windows explorer dates to match Word dates John Microsoft Word Help 0 October 17th 05 11:30 PM
Windows explorer dates to match Word dates John Microsoft Word Help 1 October 17th 05 09:26 PM


All times are GMT +1. The time now is 12:21 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"