Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2006

Tip: Looking for answers? Try searching our database.

Date calculation - for a NON-genius

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gilbert De Ceulaer - 02 Nov 2006 11:35 GMT
How do I insert a field that gives me "2007" in a letter.
I mean how do I insert a field that shows me next year.
All the previous replies give addresses of  FAQ, that require an IQ of 160,
which I do not have

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
2625 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!
Stefan Blom - 02 Nov 2006 11:45 GMT
As long as all you need to calculate is the date, it's
straightforward:

{ = { DATE \@ "yyyy" } + 1 }

To insert each pair of field delimiters, press Ctrl+F9. Type the
instructions exactly as shown. Press F9 to update.

Note that the above fields show the next year based on the current
year. That is, if the field is updated next year, it will display
2008. If you want to add 1 to the creation date of the file, use the
following instead:

{ = { CREATEDATE \@ "yyyy" } + 1 }

Signature

Stefan Blom
Microsoft Word MVP

> How do I insert a field that gives me "2007" in a letter.
> I mean how do I insert a field that shows me next year.
[quoted text clipped - 5 lines]
> 2625 spam-mails zijn er tot op heden geblokkeerd.
> Download de gratis SPAMfighter vandaag nog!
Stefan Blom - 02 Nov 2006 11:52 GMT
> As long as all you need to calculate is the date,

Correction: The *year*!

Signature

Stefan Blom
Microsoft Word MVP

> it's
> straightforward:
[quoted text clipped - 22 lines]
> > 2625 spam-mails zijn er tot op heden geblokkeerd.
> > Download de gratis SPAMfighter vandaag nog!
Graham Mayor - 02 Nov 2006 12:45 GMT
{DATE \@ "yyyy"} will give you the year. (CTRL+F9 for the field boundaries)
{={DATE \@ "yyyy"} +1} will give you the year + 1
If you want anything more complicated you will have to sharpen that IQ.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do I insert a field that gives me "2007" in a letter.
> I mean how do I insert a field that shows me next year.
[quoted text clipped - 5 lines]
> 2625 spam-mails zijn er tot op heden geblokkeerd.
> Download de gratis SPAMfighter vandaag nog!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.