my $query = $dbh->prepare("SELECT idOutbound, type, DAY(dateDue) FROM LD_Outbound WHERE (dateDue >= ? AND dateDue < ? + INTERVAL 1 MONTH) OR (defaultDate >= ? AND defaultDate < ? + INTERVAL 1 MONTH)"); $query->execute("$last_y-$last_m-01", "$last_y-$last_m-01", "$last_y-$last_m-01", "$last_y-$last_m-01"); #### 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();