Calculate a future date

I want to calculate a future date based on a date in my database when
I do a mail merge. My database does not have this furture date so I
cannot pull it directly.

Example: The database has a purchase date of 4/22/04. I want the
letter to say "Your vehicle is due for it's first oil change on
07/22/04." I need to add 90 days to the purchase date to get my
future date.

Any suggestions?

Hi,

You'll need a very complex field to do this. You can start by downloading
the document at
http://www.wopr.com/cgi-bin/w3t/show...&Number=249902
which has a number of such fields that you can work with.

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.

BTW, you do not want to post your real email address on these newsgroups.
You become a spam magnet.
--

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.

"Vanessa Mayfield" wrote in
message om...
I want to calculate a future date based on a date in my database when
I do a mail merge. My database does not have this furture date so I
cannot pull it directly.

Example: The database has a purchase date of 4/22/04. I want the
letter to say "Your vehicle is due for it's first oil change on
07/22/04." I need to add 90 days to the purchase date to get my
future date.

Any suggestions?

You will probably find it a lot easier to use a query in the database with
an expression that returns the future date and then use that query as the
datasource than to try and do this in Word.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Vanessa Mayfield" wrote in
message om...
I want to calculate a future date based on a date in my database when
I do a mail merge. My database does not have this furture date so I
cannot pull it directly.

Example: The database has a purchase date of 4/22/04. I want the
letter to say "Your vehicle is due for it's first oil change on
07/22/04." I need to add 90 days to the purchase date to get my
future date.

Any suggestions?