INTERACT FORUM

More => Old Versions => Media Center 17 => Topic started by: darichman on April 26, 2012, 10:16:07 pm

Title: Expression: Date Range
Post by: darichman on April 26, 2012, 10:16:07 pm

Hi guys... Does anyone know how I can create an expression that will output a range of dates?

I'm stumbling around with formatrange in the expression language, but no luck...

For example, if I have a TV show, I want it to display:
  American Dad! (2005-2012)
  [Series] ([Date Range from minimum to maximum])

Thanks in advance!

Chris

Title: Re: Expression: Date Range
Post by: MrC on April 26, 2012, 11:08:16 pm

[Series] /(formatrange([date (year)], 10, 2)/)

Title: Re: Expression: Date Range
Post by: darichman on April 27, 2012, 02:02:38 am

Thanks MrC, but not quite!

That's giving me a range of 10 years... what I'm after is a way to show the first year the show ever aired, then the latest...

Eg If a show only runs for 2008 and 2009, it would show 2008-2009, not 2000-2009.

Can this be done?

Title: Re: Expression: Date Range
Post by: 221bBS on April 27, 2012, 05:52:04 am

Only way, that I can think of, to do this is to create a relational field set to series and enter it manually. But you'll only have to enter it once for the whole series and also only need to update when the series end.