Math with Date Mergefield

S

StephenW

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
 
C

Charles Kenyon

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

StephenW

Thanks Charles I'll check it out

Charles Kenyon said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top