On my main tab i have a chart table that concats year and period (year and month) from this I use it as a filter to select periods, this works fine except when trying to select multiple years and periods, it allows selection but say:
Select all from year 2013, and up to year 2014 month 09. It actually selects all from 2013 and 2014.
why would it be doing this?
=Num#(If(Len(Year & Period)=5,Year &'0'& Period, Year & Period))
outputs "201301" etc
Like I said i can select whatever month up to a month i want within a year. However doing the same over multiple years forces it to select all months.