Dynamic Default Date Prompt

[actcognosuser]

Hello Folks,

I tried looking up the forums but I could not find a solution. If this is a repetitive post please direct me to the
right post.

Report needs to run daily for previous week.I can code this based on _day_of_the_week and case statement.
This will work with the scheduler. I can schedule it to run every day.

But I also have a prompt page and what I really need is the ability to change the dates in the prompt page when I want a different week or month.


I tried to specify default in the filter . When I try to schedule it i unchecked the Prompt for values.
But it doesn't work.
[Date] between #prompt('FromDate','date','_add_days(current_date,-8)')#
and
#prompt('ToDate','date','_add_days(current_date,-1)')#.

[actcognosuser]

Found a solution from previous posts.

Thank you Nimrod Avissar.

http://www.cognoise.com/index.php?topic=26481.0