$sth = $dbh->prepare(<execute($end_date); my $res = $sth->fetchall_arrayref;