Hi ,

I am novice to report designer, we want to pass filter as interval -1 day to -3 days
so there is query in mysql as follows:-
SELECT DATE(NOW()-INTERVAL 01 DAY)
so we don't want to directly specify 01 day we want to pass it as parameter.(SELECT DATE(NOW()-${p_day}))
So for that i have create a temporary table which will store p_day value as 1 and 3.

But the query is not working.It seems bit challenging to me.We are using this approach because client wants to use different timezones if this is solved hopefully we can use hours in place of days parameter.

if anyone has any idea about how to execute this please let me know.Or if there is any other solution please help.