Math with Date Mergefield

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StephenW - 05 Jan 2005 16:45 GMT

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

Reply to this Message

Charles Kenyon - 05 Jan 2005 17:08 GMT

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.

Signature

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.

>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
[quoted text clipped - 6 lines]
> Is there a way to do this calculation?
> Thanks Steve

Reply to this Message

StephenW - 05 Jan 2005 18:11 GMT

Thanks Charles I'll check it out

> 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
[quoted text clipped - 11 lines]
> > Is there a way to do this calculation?
> > Thanks Steve

Reply to this Message