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