CiviCRM Community Forums (archive)

Hi folks,

Need: 
Create a view of open cases in specific time frame.

This view would filter on dates like: 
From 1.1.2015 through 1.31.2015 and return cases that were open during that time frame.

I scoured https://www.drupal.org/node/2301019#comment-9772821 and https://www.drupal.org/node/2252215
but think it is the null end date that is messing me up.

Any ideas on how to do this?

Thanks for the reply Pete,

Don't know where I'm tripping up, but just can't get this.
Filters seem to take away any case with a start date earlier than specified date.

Created a brand new view of Cases.

Added only the Case Type field.

Created a relationship to contact id to display name of contact.

Added Display Name field to help better understand the filter results.

Added filters:
Start Date > X
and
End Date < Y
or
End Date is null

If I apply the filter to say 3.1.15-3.30.15 I only get the cases opened since 3.1.15.

So I kept playing around with combinations that made some sense to my now clouded mind.

Changed filters (see attachment):
Start Date < Y (changed exposed filter label to End Date)
and
End Date > X (changed exposed filter label to Start Date)
or
End Date is Null

This seems to work as expected.

I know I had tried this combination yesterday, but I must have not had the operators correct.

Now if I could sort them by Case Type name...

When I began this view, I thought this was the easy part!

Thanks again.