Skip to Content
0
Former Member
Jun 07, 2011 at 01:45 PM

Customizing Prompts

34 Views

I need to display a report, where it gets the current date as a prompt. But the data it interprets are like weekly basis.

For example, if the current date is 09th May 2011. The report should get the immediate last saturday (07th May) as the current week. and i need to display the data for previous weeks too. the dates to be displayed for the weeks should be a saturday.

How can i get it done?

For getting the dates of the previous week, do i need to negate 7 from the current week(07th May)?

or

Do i need to choose the start and end dates of a week (if the above is not feasible) to reduce the complexity?

Edited by: mhsrinivasan on Jun 7, 2011 3:47 PM