Filter via date in the repeater field

Hi,

I have an events page that has a list, map and calendar views. The list and map view filters using one date but the map view needs to filter using the whole month.

These are my current WHERE clause using normal pods field:

List and Map views
$where[] = "'$date' BETWEEN CAST(opening_date_time.meta_value as DATE) AND CAST(closing_date_time.meta_value as DATE)";

Calendar view
$where[] = "CAST(opening_date_time.meta_value as DATE) BETWEEN '$month_first_date' AND '$month_last_date'";

One event can be scheduled on multiple dates that’s why I opted to use repeater fields. I created a Datetime ACT (fields: date, opening time, closing time).

I’m not sure know how to implement the filter with repeater fields. Hope you can help me out.