It probably will be something like:

my $rs = [$c->model('DB::table')->search(
        { 'me.date' =>  { between => ['2013-05-03', '2013-05-04'] } }
       ,{}
    )];
[download]

Check the SQL::Abstract docs for the gritty details.