[SOLVED] Create a view of cases with date filters

[pmoz]

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?

[petednz]

Not sure if this gets close but in Views Filters, can't you make and 'and' or an 'or' group so it is basically

IF Start Date is greater than X

AND

IF End Date is less then X
OR
IF End date is null

[pmoz]

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.