Comments
-
Last day of month: DATE_SUB(DATE_ADD(`ActualDate`, interval 1 month), interval (DAYOFMONTH(DATE_ADD(`ActualDate`, interval 1 month))) day) Days in month: DAYOFMONTH(DATE_SUB(DATE_ADD(`ActualDate`, interval 1 month), interval (DAYOFMONTH(DATE_ADD(`ActualDate`, interval 1 month))) day))