Finally got the expected result with a CASE stmt.

CASE

WHEN i.delivery_due_dt < SYSDATE

...

Thank You, I will try it and let you know!

Thank You for your reply!

There is no calendar table.

database - Oracle 11.2.0.3.

Here is what I got so far.

If the Delivery_due_date is prior to the current week, then the output is...

Delivery_Date FriDay

10/01/2014 10/31/2014 ( Fri of Current Week )

The delivery_dt is stored in the Database Table.

The FriDay ( Calculated ) Date is a new column added.

Data Table