Counting records between two dates

[adriaurora]

Hi guys! Thanks in advance for your support.

Right now I have several tables in a database, one of the tables contains the events that occur, and another table contains the types of events that exist (in order to count them). The question is, how can I count only the events that have occurred in a specific month or have been involved in that month? For example, if I want to know the number of events that have occurred in May, but an event started in April and ended in June, it is not going to count if I use a conditional which searchs for event started or ended in May.

Do you have any ideas of how to implement it?

[Stephen_Orr1 · Accepted solution]

Hi @adriaurora,

I answered a very similar question recently for @grecol over here so it is still fresh in my mind 🙂

To filter a view for events that occur(ed) anytime during a specific date range, you can use the following filter logic:

Event start date is on or before your chosen range's end date AND Event end date is on or after your chosen range's start date

So to filter for events that were ongoing in May regardless of start/end dates, try:

Event start date is on or before May 31 AND Event end date is on or after May 1

Hope that helps!
-Stephen