Calculate Formula request

ok, it’s clearer with this.

I would advice you add the fields you’ll need as a criteria. So when you create a new Event, you extract :

  • Year = Date of the event :extract year
  • Month = Date of the event :extract month

and so on.

So you can filter the search based on filters which are Custom States

Have a look at the modification I’ve done and test the filter for “January”

Is it clear and solve your issue ?