Automatic Contract End Calculation
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:
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?