AnsweredAssumed Answered

Automatic Contract End Calculation

Question asked by Diegoale2000 on Feb 9, 2009
Latest reply on Feb 9, 2009 by davidhead


Automatic Contract End Calculation


Hello everyone,


I'm working on a small database to manage my Monthly Newspaper/Publication.


On the Client Management section of the database, I have something like this:


Contract Start
Contract Length

Contract End



Since my publication is monthly, i don't care about what day the contract starts/ends, Just the Month and Year.


I'd like for the Contract End to be automatically generated.


Contract Start is a Date

Contract Length is a Number (says how many months it's active since the Contract Start)



i'd like the contract end be the result of the contract date (month and year) + the length of the contract (In months)


Any idea on how to do this?