Hello, I have data set with data as BELOW: INVOICE_NO ISSUE_DATE CLOSE_DATE 1 2016-09-08 2016-09-15 2 2016-09-09 2016-09-27 3 2016-09-10 4 2016-09-11 5 2016-09-12 6 2016-09-13 7 2016-09-14 2016-09-29 8 2016-09-15 2016-10-06 9 2016-09-16 2016-09-26 W need to generate table with new column REF_DATE. The REF_DATE should cotain all dates between ISSUE_DATE and CLOSE_DATE and if invoice is not CLOSED (CLOSE_DATE is null) max REF_DATE should be Today's date. I can do this with DO loop but I would like to try DO WHILE, is there any chance to do this with DO WHILE?
... View more
