Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-10-2015, 09:40 AM
MichaelSpedding MichaelSpedding is offline Use a numerical merge field to subtract that number of months Windows 7 32bit Use a numerical merge field to subtract that number of months Office 2013
Novice
Use a numerical merge field to subtract that number of months
 
Join Date: Nov 2015
Posts: 4
MichaelSpedding is on a distinguished road
Default Use a numerical merge field to subtract that number of months

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Use a numerical merge field to subtract that number of months Spread whole number across specific months in a year rkobeyer Excel Programming 2 10-18-2014 11:46 PM
Use a numerical merge field to subtract that number of months Counting Number of Months from a static date bremen22 Excel 4 11-25-2013 11:57 AM
Use a numerical merge field to subtract that number of months Converting serial number to years, months and days hannu Excel 6 02-14-2013 09:21 PM
Plotting Numerical and Non-numerical Data Set Ife Excel 0 04-23-2012 10:35 AM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft