hi
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.