Filter Dates

Added by luke823 4 months ago

Perhaps there's a way to do this, but if not then consider this a request.

Is it possible to have "dynamic" dates in filters? For instance, I'm trying to create a filter to display missing episodes within the tv schedule, and I don't care about episodes that haven't aired yet, so I want the air date to be less than today. (Whatever "today" happens to be).

Also it'd be nice to have a way to filter against dates of Jan 1, 0001 to get rid of all the future episodes with dates of TBA.

Thanks.


Replies (7)

RE: Filter Dates - Added by fatal 4 months ago

Hey Luke,

Unfortunately it is not possible to have a dynamic values in the filter, although I will look into it for dates as I think it would be useful, but, I don't know if it will be possible using the custom filter editor.

Also it'd be nice to have a way to filter against dates of Jan 1, 0001 to get rid of all the future episodes with dates of TBA.

Jan 1, 0001 doesn't necessarily mean it is a future episode, it just means that an air date has not been entered on TVDb. You can get around that by just adding another condition to the filter like AirDate GreaterThan 01/01/1800.

Take Care

RE: Filter Dates - Added by luke823 4 months ago

Thanks!

RE: Filter Dates - Added by luke823 3 months ago

A "Has Aired" filter option would be another way to do it.

RE: Filter Dates - Added by fatal 3 months ago

Hey,

It will not be possible to add a dynamic item to the filter editor at this time.

As for an "Has Aired" filter, how would you determine if something has been aired or not? If based on the air date, u can filter by the date already.

Take Care

RE: Filter Dates - Added by luke823 3 months ago

Well Has Aired would compare air date vs today's date, so that it doesn't have to be entered every time the filter is run.

RE: Filter Dates - Added by fatal 3 months ago

Hey,

Yeah I guess I can add a new column called Has Aired and calculate that when i'm building the list (although it will get stale if you don't refresh past 12am).

So basically "Has Aired" would be caculated based on "AirDate <= Today" AND "AirDate >= 1/1/1980".

Take Care

RE: Filter Dates - Added by luke823 3 months ago

Thanks that sounds great!

(1-7/7)