Skip to Content
0
Former Member
Dec 10, 2013 at 06:46 PM

How can I get my Query to return results for a period of time?

35 Views

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?

Example:

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.

Thank you