I need help setting up a date filter in views...

I have a start and an end date for my events. I want to display any and all events that will be on sometime in the next 30 days (starting or finishing). The only way I can think of to do this is to have the following logic:

startDate BETWEEN now AND now +30 days
OR
endDate BETWEEN now AND now +30 days
OR
now BETWEEN startDate AND endDate

I have a view setup that has the first two logics working (export attached), but I don't know how to get the third working.

Is this the best way to go about it, or is there an easier way?

CommentFileSizeAuthor
date_filter_view.txt7.67 KBAnonymous (not verified)

Comments

Anonymous’s picture

Anonymous (not verified) commented

Anyone able to help with this?

arlinsandbulte’s picture

arlinsandbulte commented
Status: Active » Closed (won't fix)

Hi,
I am just indiscriminately closing all support requests with no activity for more than 1 year.
If you consider this to still be a valid issue / support request, feel free to re-open.
BUT,
if you are re-opening this issue, please provide specific details on how this issue can move forward.

Thanks.