SELECT *
FROM table
WHERE date BETWEEN 2013-05-03 AND 2013-05-04;

##</code><code>##

my $rs = [$c->model('DB::table')->search(
        { 'me.date' => ???? }
       ,{}
    )];