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.
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.