my @events = $schema->resultset( 'MyTable' )->search({
                         eventdate => { '>=' => $date1 },
                         eventdate => { '=<' => $date2 }
                     });