I have problem with extract the
Minimum for month 1 and 2.
This is my sql:
OR Months=MONTH(ADDDATE(CURRENT_DATE(),INTERVAL - 1 MONTH))
AND Years=YEAR(ADDDATE(CURRENT_DATE(),INTERVAL - 1 YEAR)));
the output for Maximum and Minimum is values of month 1, I need also Maximum and Minimum values of month 2...
Start1 (from 2011/01/01 to 2011/02/21):
Maximum month 1 + (Maximum month 2*today/number of days the current month)=17247,6
- Maximum month 2 value;
- today (only day);
- number of days the current month
Hope to get an answer on this soon, thanks!