There are actually two solutions in the above post Muzicman, one for Standard View and one for Theatre View.
The Theatre View one needs some work.
Jachin99, I suggest that you set up a tab of the Standard View solution so that you can confirm there are Sports programs currently showing, for testing on the Theatre View solution. It would be no use testing it if nothing was currently showing!
Then set up a EPG View (just a new View with no Categories, and restricted to the Television Guide database) on another tab, so you can switch between the views, and add an Expression column to the View, temporarily, with just the expression "TVInfo(TimeDisplay)", then sort by [Date Recorded] so that all the programs are in showing date/time, then scroll down to the current day and time. Observe what that column displays for days before and after the current day, for times before and after now, and for the current time.
You will see that programs that are actually showing now, the column returns "Showing", and for all other times it returns either the data and time, or just the time.
So, the function works, and it is showing what we want. Using that information in an expression is a little bit tricky though.
If you look at the rules for the standard Guide in Theatre View, you will see an example of the use of the TVInfo() function:
-[=TVInfo(ChannelKeywords)&
DataType=[L
ist]]
=[H
idden]
The "&DataType=[Li
st]" is just there because multiple values can be returned for ChannelKeywords, and the "-" at the beginning is just saying "NOT", so your function should read something like:
[=TVInfo(TimeDisplay)]=[Showing]
Boom! That works. So does:
[=TVInfo(TimeDisplay)]="Showing"
[=TVInfo(TimeDisplay)]=Showing
as the square brackets, [], just restrict the criteria to exactly the value "Showing", while the '""' restrict it to including "Showing", as does not using brackets. All as explained in the Wiki.
Why does the expression need to be specified that way? Well, because that is how MC works. The function "TVInfo(TimeDisplay)" needs to be evaluated before it can be used in a comparison, hence the "=" before it. That needs to be specified as a value to compare, hence the [] brackets around that. Then a simple and normal comparison can be done. So the expression is just in the form "Value"="Showing", but determining the "Value" requires some extra work.
Try all that. It should work for you. Toggle the List Style to have a look at the different formats. The simple List stye or the Guide style look best to me. In the Guide style you can see how far into the program the broadcast is.
If you wanted to see the programs currently showing, plus any about to start, you could modify the above expression to look at Showing programs, or any stating in the next hour, for example. There is an exercise for you.
