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
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')