Expose filters in advanced report

Question

Hi, I've created a report in the advanced module and the query has filters in the SQL. I can send the link to users to run the report. My issue is I want to expose these filters in the advanced report, so when the users want to run the report, they can change the filter. For example, in the custom query, I have date modified as a filter, which should be changed every time the query is run. I want the users to be able to change this when the report is run. Is there any way the filter can be exposed to the users. 
 Thanks.

Bethel Dumbiri · Accepted Answer

Hi Bethel Dumbiri , 
 There is no way to expose the filters on advanced reports to be changed at run-time like you can with the standard report UI. For something like a filter on date modified, the best option you have is to make the SQL query more dynamic. For example, if you want it to always return records modified in the last 30 days, the filter would look like: 
 SELECT * FROM table WHERE date_modified BETWEEN NOW() - INTERVAL 30 DAY AND NOW();