How to schedule a report with dynamic dates

[kirru_alayam@yahoo.co.in]

Hi All,

The prompt page is having two date fields (StartDate and EndDate).  And When I run the report StartDate will be displayed '1 Jan 2017' and EndDate will be displayed yesterday date in the prompt page.

Now, we have a requirement like if we schedule a report it should run for last month.

For example, If I schedule a report today (March 15, 2017), the report should run for the last month from 1st February 2017 to 28th February 2017 and should not ask to select the prompt values again.

Could you please help me on this requirement.

Thanks,
Kiran

[BigChris]

This is something I use quite a lot - in fact I wrote a blog post so that I can find it when I need it:

http://cognostips.weebly.com/blog/date-prompts