Thank you for the macro to transfer field codes. That will be very useful in
the future.

I found a date calculation code that works on Woody's Lounge (posted by
macropod). Thank you for your help!

"Graham Mayor" wrote:

Because of the difficulty in manually reproducing such complex fields there
are a couple of errors in your post that make it even more difficult to read
and if they are exactly culled from your document would contribute to the
error. What exactly are you trying to achieve?

You might do better downloading the most recent version of original document
on which such calculations were based. This is linked from
http://www.gmayor.com/insert_a_date_...than_today.htm (and from
Charles's site)

Paste the code from the source document into your merge document and use
replace to change DATE to Mergefield SALEDATE.

The macro at http://www.gmayor.com/export_field.htm will make the transfer
of field codes to text for messaging much easier.

--

Graham Mayor - Word MVP

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



Lani wrote:
I am using Microsoft Word 2002. I copied the following code from
www.addbalance.com (I changed the bookmark name and number of days
being subtracted):

{QUOTE {SET Delay "29"}}{SET "NextPrevMonth" {IF {SALEDATE \@ "MM"}
= 1 "12/97" "{ = { SALEDATE \@ "MM"} - 1 }/97" }}{SET "DaysInMonth"
{IF { NextPrevMonth \@ "MM"} 2{ = INT(30575*{NextPrevMonth \@ "MM"
}/1000+1/2)-INT(30575*{ ={NextPrevMonth \@ "MM"} - 1 }/1000+1/2) }{
IF { = INT({SALEDATE \@ "yy" }/4) } = { = { SALEDATE \@ "yy"}/4)
}"29" "28" } } }{ IF { = {SALEDATE \@ "dd"} - {REF Delay \*
MERGEFORMAT} } 0{QUOTE { SALEDATE \@ "MMMM" }" "{ = { SALEDATE \@
"dd" } - { REF Delay \* MERGEFORMAT } \# "0" }", "{ SALEDATE \@
"yyyy"}""}{QUOTE {NextPrevMonth \@ "MMMM" }" "{ = { SALEDATE \@ "dd"}
- ( REF Delay \* MERGEFORMAT} + {DaysInMonth} \# "0" }", "{ IF {
SALEDATE \@ "MM"} 1 { SALEDATE \@ "yyyy"}{ = { SALEDATE \@ "yyyy"}
- 1 \# "xxxx"}}""}}

When I merge the document with any SALEDATE in March, I receive an
error page that reads "A field calculation error occurred in record
2." When I close the error page, the document I merged is underneath
and the calculation is correct (unless the SALEDATE is 03/01/2006
then it merges February 0, 2006). I suspect that this has something
to do with February only having 28 days. Can anyone tell me what I
can do to eliminate the error? Also, as an added bonus, does anyone
know how I can change the code so it won't merge February 0, 2006?