11-08-2017 04:43 PM - edited 11-08-2017 04:45 PM
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?
chosen period: 04feb19 - 18feb19
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.