Date 7 days in advance in merged word doc

[Who me?]

Can anyone please help, I wish to have entered automaticly the system date
plus 7 days, I'm sure that there must be an easy way of doing this but I can
not think of it. Help. Office 2000, merging fields from an Access data base.

Roy........

 

[Charles Kenyon]

You can do this with a field. The following one will do it but is very
difficult to type in by hand. I got it using the Add-In downloadable from
Chris Woodman's site at:
http://www.chriswoodman.co.uk/Delayed Dates.htm

{ QUOTE "{ SET " Delay" "7" }
{ SET "DaysInMonth" { IF { CreateDate \@ "MM" } <> 2
{ = ROUND(30.575*{ CreateDate \@ "MM" },0)-
ROUND(30.575*{ = { CreateDate \@ "MM" } -1 },0) }
{ IF { = MOD( { CreateDate \@"yy" } , 4 ) }

0 "28" "29" } } }

{ SET "NextMonth" { IF { CreateDate \@ "MM" } = 12 "1/97"
"{ = { CreateDate \@ "MM" } + 1 }/97 } }
{ IF { = { REF "Delay" } + { CreateDate \@ "dd" } }
<= { REF"DaysInMonth" }
{ CreateDate \@ "MMMM { = { REF "Delay" } +
{ CreateDate \@ "dd" } }, yyyy"}{ QUOTE { NextMonth \@ "MMMM" }
{ = { REF "Delay" } + { CreateDate \@ "dd" } - { REF"DaysInMonth" } },
{ IF { CreateDate \@ "MM" } <> 12 { CreateDate \@ "yyyy" }
{ CreateDate \@ "{ = 1 + { CreateDate \@ "yyyy" }
\# "xxxx" }" } } } }" }

When creating fields from the keyboard the field braces are typed using
Ctrl-F9.
The line breaks should not be part of the field. The field's complexity is a
result of the complexity of the calendar, itself.

Hope this helps.
--

Charles Kenyon

See the MVP FAQ: <URL: 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.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

The easiest thing to do will be to use a Query in Access as the datasource
and in that Query, include the following expression

Format(DateAdd("d",7,Now()),"mmmm d"", ""yyyy")

Data bases are much better at data manipulation than Word Processors.

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

 

[macropod]

Hi Roy,

Go to:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902
(url all one line)
Where you can download a Word document for doing this & more with dates,
using Word fields instead of vba. All the hard work's been done for you.

Cheers