Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge of a calculated date produces an error
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Field Merge | Mailmerge | |||
Merge Date Error with change in calendar year | Mailmerge | |||
How do I omit an empty date merge field? | Microsoft Word Help | |||
Wrong mail merge date format | Mailmerge | |||
Help! I'm getting error messages too much-can't open Resume Wizard | Microsoft Word Help |