I have got to generate a report, so i am trying to fetch extract data on the basis of the frequency. The frequency are Daily, Weekly, Fortnightly, Monthly. I also have the run date, ie the date by which the report is to be shooted. Now the problem how do i extract data where the report is fortnightly and date is not fixed.
Say certain monthly reports are marked to be sent on 1st of every month, certain on 7th and so on.
Similarly, there are reports which are bi-weekly, ie has to be sent on MON and Thu.
How can i fetch these with ease. There are around 200 reports. So what i am trying to do is just run the extract to get the list of reports which are due on the said date. So if the date is 7, any report which has rundate as <=7 and status is PENDING should be fetched.
Hope i am unable to put my query thru.
Please assist.
Say certain monthly reports are marked to be sent on 1st of every month, certain on 7th and so on.
Similarly, there are reports which are bi-weekly, ie has to be sent on MON and Thu.
How can i fetch these with ease. There are around 200 reports. So what i am trying to do is just run the extract to get the list of reports which are due on the said date. So if the date is 7, any report which has rundate as <=7 and status is PENDING should be fetched.
Hope i am unable to put my query thru.
Please assist.