HiI have a query that will generate records monthly based on the number of months that i calculate between two date feilds for a given requestid. How can i use the same query to generate records for weekly and bi weekly based on the receiveddate feild that i use in the subtraction for calculating the number of months.

Also when inserting i have been adding a month for every record as i was generating monthly and now i would have to add week and 2 weeks to the receiveddate

We get a request through an intake webform and within the request the user selects a recurring frequency.This frequency is used by us to send the user the reports that they are looking for.

So for exmaple a request comes in Jan 2014 with frequency selected as monthly and the expiration date is Dec 2014. we have to send the user monthly reports until Jan 2014 for which my monthly logic submits requests and one of our team member uses that automatic request that the system generates to process that monthly requests

Now we have a requirement to generate weekly requests and biweekly requests for which iam not sure how to make use of my existing logic.

We need to generate requests weekly and biweekly automatically so that our team members can use them

On a monthly basis I identify recurring requests within our system which have been completed and for which we need to generate off cycles based on the frequency selected within the original requestWe have in total four types of frequencies that the users can select while submitting the first request and they are Quarterly, Monthly, Weekly, Biweekly.

The offcycles that the system generates are going to be used by the analysts to complete monthly or weekly

Below is sample data for original request and the off cycles that I generate based on the cursor code providing the original request id

Sorry for the late response as i did not get notification this time . The start date is based on the original request completion date.the original request was completed on 1/15/2014 so we have to start generating offcycles for it from a week later to the starting date