Need to display past week data

[lifzgud]

For eg.
If i run the report on Monday or any other weekday , it should show me the data from last weeks saturday to the present week's sunday

eg. If i run the report on 14th sept 2009 it should show me data from 6th to 12th sept.There is a date column present in my report that i am using in the filter
Any idea on how to go abt this?

[sridharansathya]

case when to_char(sysdate,'Day') in ('Monday' )
then date between add_days(to_char(date),'-8') and add_days(to_char(date),'-1')
to_char(sysdate,'Day') in ('Tuesday' )
then date between add_days(to_char(date),'-9') and add_days(to_char(date),'-2')
similarly till friday

I have just framed the logic , not tried with it........
Please check this logic whether it suits or not and let me know.........

Sathya.