Hello all, I need some help with one of my programs. Any help is appreciated. Thanks in advance. I have a data set called CALLS which consists of 3 columns: Date Calls Made Calls Cancelled 05/01/2018 5000 2000 06/01/2018 5800 2300 07/01/2018 7600 2100 08/01/2018 6600 1000 09/01/2018 5600 3400 10/01/2018 4400 2500 11/01/2018 3400 2400 This programs runs once, every month end and inserts the new row into the table. The new requirement is that I need to run the program monday of every week and replace the last row with that day data until the end of the month when the row is recorded into the table as the month ending value. Next month the same is continued until the month end. What I mean is: November- week1 (Monday) Date Calls Made Calls Cancelled 09/01/2018 5600 3400 10/01/2018 4400 2500 11/01/2018 3400 2400 November- week2 (Monday) Date Calls Made Calls Cancelled 09/01/2018 5600 3400 10/01/2018 4400 2500 11/01/2018 4400 2600 November- week3 (Monday) Date Calls Made Calls Cancelled 09/01/2018 5600 3400 10/01/2018 4400 2500 11/01/2018 5300 3000 End of month - November 30, 2018 Date Calls Made Calls Cancelled 09/01/2018 5600 3400 10/01/2018 4400 2500 11/01/2018 6000 4000 Dec-week1 (Monday) Date Calls Made Calls Cancelled 09/01/2018 5600 3400 10/01/2018 4400 2500 11/01/2018 6000 4000 12/01/2018 1000 400 Any help will be greatly appreciated. Looking forward to it. Thank you !
... View more