Custom Query to return the Show which is happening now

Hi Guys,

I am working on a project for my local student radio show, and I need to be able to return the information of the show which is currently happening and the show that is going to be on next. Whilst the shows vary in length, I have worked out that I need to somehow exclude the show that is on now from the next query.

I have created a post type called ‘show’ and we have custom fields for start and end. However, reading over the documentation, I am unsure on how to proceed. I need to return all of the information from the post that is selected (content, start and end times, post title (show name)).

Can anyone help? I feel defeated.