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