Date 7 days in advance in merged word doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Who me? - 09 Feb 2004 19:14 GMT

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

Reply to this Message

Charles Kenyon - 09 Feb 2004 20:01 GMT

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%20Dates.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.

Signature

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.

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

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 09 Feb 2004 23:14 GMT

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.

Signature

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

> 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
[quoted text clipped - 3 lines]
>
> Roy........

Reply to this Message

macropod - 11 Feb 2004 21:05 GMT

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

Reply to this Message