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?
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