my $query = $dbh->prepare("SELECT idOutbound, type, DAY(dateDue) FROM LD_Outbound WHERE (dateDue >= ?:NOW AND dateDue < ?:NOW + INTERVAL 1 MONTH) OR (defaultDate >= ?:NOW AND defaultDate < ?:NOW + INTERVAL 1 MONTH)"); $query->bind_param(:NOW, "$last_y-$last_m-01"); $query->execute();