Thanks for the response but I find it hard to believe Oracle does not
provide that functionalityor some derviation of it.

Ie

SQL> select sysdate from dual;

SYSDATE
---------
14-MAR-11

SQL> select NEXT_DAY ('01-MAR-11', 'MON') from dual;

NEXT_DAY(
---------
07-MAR-11

There has to be some way of doing this? Maybe subtracting 5 weeks from
the current date and than finding the next occurance of that day?

Any examples or input would be greatly appreciated.