I have a mail merge with several date fields. I need to subtract 1 day from
one of them and also have this new date printed on my form. I've tried using
the {CALCULATE } merge field and {={MergeField R_Date}-1} and it does the
math on the field using the /'s in the date for division. I've try using {Set
RD "{Mergefield R_Date}"}{Set CD "{={Ref RD}-1}"} and it also does the
division.
Is there a way to do this calculation?
Thanks Steve

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 pages
with fields and an explanation of different macros that can be used instead
of fields.
--

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://www.mvps.org/word 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.

"StephenW" wrote in message
...
I have a mail merge with several date fields. I need to subtract 1 day from
one of them and also have this new date printed on my form. I've tried
using
the {CALCULATE } merge field and {={MergeField R_Date}-1} and it does the
math on the field using the /'s in the date for division. I've try using
{Set
RD "{Mergefield R_Date}"}{Set CD "{={Ref RD}-1}"} and it also does the
division.
Is there a way to do this calculation?
Thanks Steve

Thanks Charles I'll check it out

"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 pages
with fields and an explanation of different macros that can be used instead
of fields.
--

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://www.mvps.org/word 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.

"StephenW" wrote in message
...
I have a mail merge with several date fields. I need to subtract 1 day from
one of them and also have this new date printed on my form. I've tried
using
the {CALCULATE } merge field and {={MergeField R_Date}-1} and it does the
math on the field using the /'s in the date for division. I've try using
{Set
RD "{Mergefield R_Date}"}{Set CD "{={Ref RD}-1}"} and it also does the
division.
Is there a way to do this calculation?
Thanks Steve