2 Replies Latest reply on Jun 3, 2015 10:23 AM by jasheldo

# Calculate a contract end date given the duration and start date

Hello.  This may be a huge oversight on my end with the capability built in and easily executed but I'm not seeing it.  One way I use FMP is to track lease payments and contract durations.  I think it's silly that I'm manually entering in the contract end date when I'm already entering in the start date of the contract and the duration of the contract.  How can I get FMP to calculate the contract end date for me automatically given these two pieces of information.

For example, a contract that begins on 5/1/2015 and runs for 12 months ends on 4/30/2016.  I'd like FMP to calculate the 4/30/2016 for me.  Or, if the contract begins on 5/1/2015 and lasts for 11 months then the final contract date is 3/31/2016.  I'd like the 3/31/2016 to be an auto calculation.  How do I make that happen?

• ###### 1. Re: Calculate a contract end date given the duration and start date

jasheldo wrote:

the capability built in and easily executed

Indeed it is; you can do math with dates, and trust that FM will take care of any carry-overs.

Therefore, try

Date (

Month ( contractDateStart ) + contractDurationInMonth ;

0 ;

Year ( contractDateStart )

)

where a day value of 0 gives you the last day of the previous month (and adjusts the other values).

• ###### 2. Re: Calculate a contract end date given the duration and start date

Fantastic.  Easy as pie.  Thank you for taking the time to help me with that.