v_mobiledata_billingdates

select `labtech`.`mobiledeviceinfo`.`MobileID` AS `MobileID`,(((makedate(year(now()),1) + interval month(now()) month) - interval 1 month) + interval (`labtech`.`mobiledeviceinfo`.`DataPlanBillingDate` - 1) day) AS `FirstDate`,(((makedate(year(now()),1) + interval month(now()) month) + interval (`labtech`.`mobiledeviceinfo`.`DataPlanBillingDate` - 1) day) - interval 1 day) AS `LastDate` from `labtech`.`mobiledeviceinfo` where (`labtech`.`mobiledeviceinfo`.`DataPlanBillingDate` < dayofmonth(now())) union select `labtech`.`mobiledeviceinfo`.`MobileID` AS `MobileID`,(((makedate(year(now()),1) + interval month(now()) month) - interval 2 month) + interval (`labtech`.`mobiledeviceinfo`.`DataPlanBillingDate` - 1) day) AS `FirstDate`,((((makedate(year(now()),1) + interval month(now()) month) - interval 1 month) + interval (`labtech`.`mobiledeviceinfo`.`DataPlanBillingDate` - 1) day) - interval 1 day) AS `LastDate` from `labtech`.`mobiledeviceinfo` where (`labtech`.`mobiledeviceinfo`.`DataPlanBillingDate` >= dayofmonth(now()))