Microsoft Office Forums - View Single Post - Use a numerical merge field to subtract that number of months

MichaelSpedding · 11-11-2015, 03:35 AM

Hi,

thanks for your response.

Code:

{  QUOTE
{ SET Delay -{MERGEFIELD Unit_Lease_Dates_Notice6}}  
{ SET mm =MOD(ABS( {MERGEFIELD Unit_Lease_Dates8 \@ M} +Delay+11),12)+1}} 
{ SET yy {=INT( {MERGEFIELD Unit_Lease_Dates8 \@ yyyy}+(Delay+ {MERGEFIELD Unit_Lease_Dates8 \@ M}-1/12)}}  
{ SET dd {=IF(( {MERGEFIELD Unit_Lease_Dates8 \@ 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)+( {MERGEFIELD Unit_Lease_Dates8 \@ d}>30)>1,30, {MERGEFIELD Unit_Lease_Dates8 \@ d}))  
" dd - mm - yy " \@ "d MMMM, yyyy”  }

This is what I have tried with no joy... it is bringing back 1 March, 2015 :(

What am I doing wrong?

also, apologies about cross posting, I'll play the ignorance card this time, won't happen again!