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