I want to make a smart report that will bring back only results within a 6 month period between current and 180 days from current. I do not see an easy way to do this so that I don't have to address the prompt everytime I run the report. I would prefer to do this at the Query Filter level rather than in the universe or in the SQL. Does anyone know how to make this work?
Bob has a start date of 1/24/2013
Jan has a start date of 7/1/2014
I want the query filter setup so that it will return Bob's result in the report because it is within 180 days of today, but it won't return Jan's results until I run the report at the end of January. I know that I can do this at the universe level or write it directly into the SQL, but that would require IT intervention. It is needed because track changes only highlights those items that have changed on the report based on the query run vs. the Input Controls setup at the report level.