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