Recurring intervals overlapping chosen period?

Number7 — Wed, 08 Nov 2017 21:45:46 GMT

Im looking for an optimized way to decide if a recurring period overlap one or several times with an chosen interval.

I have a list of Jobs, with a startdate and a interval(Same for every job).

I want a function that returns startdate and enddate of the interval(s) overlapping the chosen period.

Is there any optimized way to do this with Programming?

Lets say:

chosen period: 04feb19 - 18feb19

Recurring intervall:

Start: 15jan18.

Duration: 13days

Recurr every 6 weeks. until forever..

Should I use some kind of solve function combined With INTNX? or mod?

Thank you for every input I can get.

Re: Recurring intervals overlapping chosen period?

error_prone — Wed, 08 Nov 2017 21:57:57 GMT

Please post sample data as data-step and include the expected output.