Hi,

I am trying to enter a 'notice date' into a merge field however the software we use holds this as a numerical value in months (e.g. '6' months notice, as opposed to 'notice date 01/01/16').

What I have is:



{QUOTE
{SET NoticeDate{MERGEFIELD Unit_Lease_Dates8}}
{SET Delay - {MERGEFIELD Unit_Lease_Dates_Notice6}}
{SET mm{=MOD(ABS({NoticeDate \@ M}+Delay+11),12)+1}}
{SET yy{=INT({NoticeDate \@ yyyy}+(Delay+{NoticeDate \@ M} - {MERGEFIELD Unit_Lease_Dates_Notice6}/12}}
"{NoticeDate \@ D}{mm}{yy}" \@ MMMM D, YYYY}


Unit_Lease_Dates8 = 1 Mar 2019
Unit_Lease_Dates_Notice6 = 6


The result that is being returned is January 3, 2015


Obviously this is incorrect (it should be 'September 1, 2018' - pretty close I think...), however, this is my first venture into Word merge field codes (or whatever the technically correct name for them are) so please forgive my lag of ability. I have cobbled this together from various sources but would like some assistance in pulling it all together.