How to restrict the date values

[RealEstate2018]

Hi team,

Can someone please help restrict my data value so that my bar chart doesn't display data before today's date?  I want to display all data from today's date until the next 5 years.  Shown below is the expression I have put into the script.  Do I need to modify it or put something into the dimension limits?  It works just fine however, it's displaying one location that has an expiration date of 9/14/17 (well before today's date)

only({<Year = {"<=$(=max(year(today())) + 5)"}>} Expiration)

[Vegar · Accepted solution]

You need to define both a min year and a max year.

only({<Year = {">=$(=year(today()))<=$(=year(today()) + 5)"}>} Expiration)

You don't need the max() as you only have one value inside it, today().