Hi I need to run a weekly report of the month every monday. Let say now month is December. The first report I need to run is on Monday (3rd-Dec-2018) which is fall in Week2 of Dec. How I'm going to get the start and end date of the previous week? Below is when the report should be run/generated. Week1 report will be run in Monday Week2 : start=01-DEC-2018 , end=02-DEC-2018 Week2 report will be run in Monday Week3 : start=03-DEC-2018 , end=09-DEC-2018 Week3 report will be run in Monday Week4 : start=10-DEC-2018 , end=16-DEC-2018 Week4 report will be run in Monday Week5 : start=17-DEC-2018 , end=23-DEC-2018 Week5 report will be run in Monday Week6 : start=24-DEC-2018 , end=30-DEC-2018 Week6 report will be run in Monday Week1 of the following month. In this case Jan 2019 : start=31-DEC-2018 , end=31-DEC-2018 Thank you in advance.
... View more