Date fields From->To with filterBy

[possible_books]

I am trying to set up pages that contain two dates: “From” and “To” and would like to filter pages out, if the current date isn’t between from and to.
I assumed, this could be done with:

  $items = $page->children()->filterBy('date', '>', time());

but it seems, this only works with one field, and its name has to be “date”.

What i like to have is this:

  $items = $page->children()->filterBy('from', '<', time())-> filterBy('to', '>', time());

but this doesn’t work, as far as i know.
Do you have an idea for an elegant solution?

I think this could make sense, when you have a list of subpages and want to divide it into current and past items.

I looked into these threads:

Date field (online from, to)

Okay, did u test this code ? Im going to implement it! Mercii

filterBy for current year

Assuming I have date fields in my pages like Date: 2015-11-01 and I would like to get the number of pages of the actual year like $noOfPages = $pages->find('blog', 'post') ->children() ->visible() ->filterBy('date', '*=', date('Y'))->count(); I get zero pages in Kirby 2.2 – What am I doing wrong?

but couldn’t find a solution.

Thanks,
Matthias

[texnixe]

Check out this thread, basically, it works with a filter with callback, you just need to adapt the code a bit: Multiple date fields in 1 markdown file?

[possible_books]

Works perfectly! Dankeschön.