Unanswered: How to calculate a date and a whole number
I have a table holding contractual data such as the date the contract was signed, the term of the contract as well as other data. I was wondering if it was possible to calculate the expiration date using the number of months that the contract is valid plus the contract start date.
If this is possible, can someone please tell me what type of query I would need to use? The two relevant fields are:
The first contract would expire 2008-04-03 and so on..
What I would like to do is get the current status of the contract by using this formula. Is this possible or should I add another column for the end_date?
Is there a cheat sheet or something I can reference with regard to mysql functions? Like a quick reference? I know I can use the mysql site but sometimes it is like looking for a needle in a haystack especially if I'm not really sure what I need.