Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[imugli]

While this question is specifically related to the TV guide function, it isn't confined to that, thus I'm placing the thread here...

Is there a search string I can use to create a smartlist (or Theater View Scheme) that will find me all TV shows for *the present date* that start between x and y times?

I say *present date* because I want it to be dynamic i.e each day I want it to show the prgrams between 6 - 10pm for that day.  
I have the date field populated and have created a Start Time field, but how to get it to find *the present day's* shows?

Then also, how to extrapolate that into show data for next 7 days, so between *present date* and *present date + 6 days*

Any help would be great.


Solution:

The rule I used to find all of today's programs is:

[=isequal([Date Recorded],formatdate(now(),d//MM//yyyy),8)]=1

courtesy in part to the thread at

http://yabb.jriver.com/interact/index.php?topic=56487.0

And to find those starting between time A and time B is:

[=IsRange(math(math(mid([date recorded],11,2)*3600)+math(right([date recorded],2)*60)),64800-77400)]=1

where the time range (18:00 - 21:30) is reflected in seconds i.e 18*3600=64800.

Note: Your system needs to display time in HH:mm format for this to work.

Thanks to @Lasse_Lus for this part.

[Lasse_Lus]

imugli, start with this thread http://yabb.jriver.com/interact/index.php?topic=56487.0

[imugli]

Thanks Lasse_Lus,

I found it about 2 minutes before you posted 

Will post the result when I have it.

[marko]

[imugli]

Hi Guys,

I got the Show Date part of it working great, now I'm trying to get the "Prime Time" part of it happening.

I'm testing it on another smartlist (before even attempting to combine it  )

I have the search expression

[=isrange([Date Recorded],18:00-21:30,8)]=1

but it's not working. It's showing ALL items in the list, as if it's not recognising the range.

I can do

[=isequal([Date Recorded],18:00,8)]=1

and it shows all items containing that time, just the range search doesn't seem to be working...

Any help is appreciated.

Justin.

[Lasse_Lus]

what if you convert to time to seconds ?

like

[=IsRange(math(math(mid([date recorded],11,2)*3600)+math(right([date recorded],2)*60)),64800-77400)]=1

where every hour is 3600 seconds, so 18:00 is 64800 seconds and 77400 = 21:30

[imugli]

I could reach through the interweb and kiss you!

You're a legend - thanks Mate!