What I am trying to do is filter a table from a control box with a specific set of date ranges. I thought I might be able to setup a lookup table that has the date ranges and pull from that, but I haven’t been able to figure out how to make that work. For example we work within a fiscal year that runs from 7/1 of one year to 6/30 of the following year. I want to be able to filter by the fiscal year without having to select the starting and ending date every time. I setup a table that has a Start Date column and and End Date column with the dates for several fiscal years and was hoping I could use those two columns to select my date range.
Does anybody know how to make this work or have a better suggestion?