Re: Formulas in Word

[Doug Robbins - Word MVP]

Hi Cathy,

You will probably need to update the fields in the document. When you use
DATE in the formula, the date will be based on the date at the time that you
update the fields. If you use CREATEDATE, it will be based on the date that
the document was created. SAVEDATE will give date based on the date the
document was last saved and PRINTDATE will give a date based on when the
document was printed.

Please respond to the newsgroups for the benefit of others who may be
interested.

Hope this helps
Doug Robbins - Word MVP
----- Original Message -----
From: Cathy Allford
To: Doug Robbins - Word MVP
Sent: Thursday, July 10, 2003 4:48 PM
Subject: I nust be having a really hard day!


Doug,

I still can't seem to get the formula to work in word.

I have a form letter I sent to clients with a Listing Agreement. The
listing agreement is usually for 1 year. What I want is for Word to use day
's date for example, but where the expiration date of the contract goes, I
want Word to automatically fill that date in (one year from today for
example). I use Ctrl F9 all the time for but do not want to fill in in the
date, I wanted the formula to do it for me if possible.

Thanks for your help!

Catherine (Cathy) Allford
Realtor
A & A Home Buyers Realty, Inc.
1357 McCall Rd
Port Charlotte, FL 33981
Phone: (941) 697-9210
Fax: (941) 697-3041
Cell: (941) 830-2111
www.FloridaHomesHere.com
Hi Cathy in FLA,

Use the following field construction:

{ DATE \@ "MMMM d" }, { = { DATE \@ "yyyy" } + 1 }

You must use Ctrl+F9 to insert each pair of field delimiters { }

Please respond to the newsgroups for the benefit of others who may be
interested.

Hope this helps
Doug Robbins - Word MVP

 

[macropod]

Hi Cathy,

Your solutuion will work fine except for Feb 29 in leap
years. If that is a problem, let me know and I'll show you
how to deal with that too.

Cheers

PS: Remove NO.SPAM from the above before replying.