need help understanding mailmerge code

lhuffst · #1 02-13-2013, 07:36 AM

I am new to mailmerge and do not understand all of the following code.
It is supposed to return the first day of the next month of the formfield (orgdate). If the date is null then use current date.
What I get is the first date of the last month

When I went through the code, I realized that I didn't really understand all of the lines of code and am hoping someone can explain it to me, particularly the mod statements.

Code:

Effective Date: {QUOTE{QUOTE
{SET ORGDATE {IF{ MERGEFIELD "InvoiceDate"}="" {MERGEFIELD "Date_Stamp" \@ 
M/d/yyyy} {MERGEFIELD "InvoiceDate" \@ M/d/yyyy}} }
{SET Delay 1}
{SET mm {=MOD(ABS({ORGDATE\@M}+Delay+11),12)+1}}
{SET yy{=INT({ORGDATE}\@ YYYY}+(dELAY+{ORGDATE \@ M}-1)/12)}}
{SET dd{=IF(({ORGDATE}\@ D}>28)*(MM=2)=1,28+((mod(yy,4)=0)+(MOD(yy,400)=0)-
(MOD(yy,100)=0)),IF((mm=4)+(mm=6)+(mm=9)+(mm=11)+{ORGDATE\@ d}>30)>1,30,{
ORGDATE \@ d}))}}
"{delay}-{mm}-{yy}" \@ "M/d/yyyy"}}

Thanks

macropod · #2 02-13-2013, 05:19 PM

Your OrgDate test doesn't say "If the date is null then use current date". What it says is "If the Invoice date is null then use date_stamp date, otherwise, use the Invoice date" - both as the basis for doing a date calculation.

Be that as is may, you're using entirely the wrong field code if all you want is the first day of the next month. For that the field code would be:

Code:

{QUOTE
{SET StartDate {IF{MERGEFIELD InvoiceDate}= "" {MERGEFIELD Date_Stamp \@ M/d/yyyy} {MERGEFIELD InvoiceDate \@ M/d/yyyy}}}
{SET Delay 1}
{SET m{=MOD({StartDate\@ MM}+Delay+11,12)+1}}
{SET y{=INT({StartDate\@ yyyy}+(Delay+{StartDate\@ M}-1)/12)}}
"{m}-1-{y}" \@ "M/d/yyyy"}

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	8	02-11-2013 04:40 AM
Mailmerge to Email with a mailmerge attachment	Baldeagle	Mail Merge	13	05-29-2012 02:04 PM
Mailmerge	dkub	Mail Merge	35	12-07-2011 11:35 PM
Help with mailmerge???	foxtrot1981	Mail Merge	0	12-03-2010 08:21 AM
Understanding .docx XML tags for better performance	RithanyaLaxmi	Word	1	03-08-2010 01:41 AM