I'm building a radio station page with Drupal 7, and I would like to display in a block the current show on air, but I can't find a way to do it. I have installed the Views, Calendar and Date modules, a show content type with the starting date (and hour) and the ending date (and hour too). How show the query and filtering be done in views to display only one show and the one that is currently at the same time as the system time?
Basically, you want to tell views to display nodes with
starDate <= *NOW* AND endData >= *NOW*. i.e. if now is 11:50, a program from 11 - 12 should be displayed.
This could be done fairly easy via views, following are two screenshots of the two filters you're gonna add to the view:
Hope this helps.