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 2004

Tip: Looking for answers? Try searching our database.

Need to Calculate date in merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott Sanford - 31 Oct 2004 19:04 GMT
Hello,
I have the need to calculate a date + 21 days from the date that a merge
form is actually merged. I did a Google search and looked into the forums,
but found nothing.

Any help would be greatly appreciated.

Thanks.

P.S. I did try the following from Calculate Date Field.doc:

{ QUOTE "{ SET Delay "14" }{ 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" } } <= { DaysInMonth }{ CREATEDATE \@ "MMMM { = { REF
Delay} + { CREATEDATE \@ "dd" } }, yyyy"}{ QUOTE { NextMonth \@ "MMMM" } { =
{ REF Delay } + { CREATEDATE \@ "dd" } - { DaysInMonth } }, { IF { }
CREATEDATE \@ "MM" } <> 12 { CREATEDATE \@ "yyyy" }{ CREATEDATE \@ "{ = 1 +
{ CREATEDATE \@ "yyyy" } \# "xxxx" }" } } } }" }

but I get Integer Expected Error...
Graham Mayor - 01 Nov 2004 08:45 GMT
Given the difficulty in transcribing complex field constructions like this
into real fields, whilst still ensuring that everything is present, it would
help you if you simply copied the construction from a template that contains
it - see
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902

Signature

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

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

> Hello,
> I have the need to calculate a date + 21 days from the date that a
[quoted text clipped - 20 lines]
>
> but I get Integer Expected Error...
Scott Sanford - 02 Nov 2004 03:44 GMT
Thanks, will try.
> Given the difficulty in transcribing complex field constructions like this
> into real fields, whilst still ensuring that everything is present, it
[quoted text clipped - 28 lines]
>>
>> but I get Integer Expected Error...
 
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.