How can we apply filter in view for a content type by start date-time and end date-time?

Question

I want to show the latest exam on a tablet based notice board. I am using Drupal 7.

For this I need to show an item from a content type called Exams which has a start date and end date with time. After the time ends I need to show the next item if there any.

We can apply start date and end date filter, but I want to check the time also.

For e.g.

An exam starts on 28/01/2015 10:00 am and ends on 28/01/2015 11:30 am. If I will add another exam starts at 12:30 pm at the same day after the first exam I need to show the second one automatically.

How can I accomplish this condition ? Seeking the help from Drupal experts.

Answer 1

Try the Scheduler module, then just create a view with published exams.

This module allows nodes to be published and unpublished on specified dates.

Dates can be entered either as plain text or with calendar popups. To use calendar popups you need to install the Date Popup module, which is part of the Date module.