Last Week Monday to Friday Dates to be displayed in Report Period

[Toushila]

Hi All,

I've to display in my report Last week Monday to Friday Dates in my Report Period and the report will be run on Monday of current week.

Example:
Today is June 5th 2008,Thursday . 
Monday is June 2, 2008 -- This is the day the report will be run and it should display the Report Period as:

Report Period:  May 26, 2008 TO May 30, 2008.

Did anyone encounter such requirement? Please share your insights...... and thanks in advance for the help!

Cheers,
Toushila

[utsabsengupta]

 For last week dates from Monday to Friday Use:To_char(sysdate()-5 -TO_NUMBER(TO_CHAR(SYSDATE(),'D')) ,'MON DD') to To_char(sysdate()-1-TO_NUMBER(TO_CHAR(SYSDATE(),'D')) ,'MON DD')