I want to calculate the % through the month. So (total days in month-current date)/total days in the month.
Does anyone know the beastmode to do this?
@juliannarenaud, did Shevy's reply help you out?
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))