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

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