Drupal 7: Filter nodes with a date range arround an exposed date My issue is somewhat opposite of the common "List nodes within a date range".

So, I have an Event content type, with fields start_date and end_date. They show when the event starts, and when the event ends. Now I need to be able to select a date and fetch all events for which start_date &lt; selected_date and end_date > selected_date.

The selected date should be an exposed filter to all users, or any other way that makes it possible to be fetcher from the URL.

Thanks in advance!
Have you tried adding an exposed filter in your view?  I'm assuming you're using a view already, and I'm assuming you're using Drupal 7 (it's always helpful to specify that in the question, by the way :-)).

Add the date in question to your list of filters, check the box to expose it to users and use the 'is not between' option.  Then you can either specify a hard coded date for the 'from' and 'to' or you can even use a relative date (second value type option) and specify something like '-30 minutes' and '+30 minutes' and it will re-calculate them based on the current time...



Hope this helps.  Let us know if it works.