Forum Discussion
Comparing date series based on different time periods.
Hi -
I don't think using an iterval is relevant here. An interval is just a duration, it does not say when the interval starts or ends.
To compare each date to see if it is inside the start date and end date you can just do a comparison like you would with a number, using >= and <= (or > and < if you want to exclude the actual start or end dates).
Hope this helps,
Peter
Hi Namesake,
I appreciate you putting your time into this to help.
Allow me to try and add some context to the issue.
The scope of the problem, involves an individual or student having a review meeting every 12weeks form start date up till end date. So at every point they have a meeting i want to check if that meeting is within the correct 12 week period given the date it happened.
Lets say they are in program for a year which translates to about 4 meetings, I am trying to see if :
Meeting 1 held between (Start date) and (Start date +12 weeks)
Meeting 2 held between (Start date + 12 weeks) and (Start date + 24 weeks)
Meeting 2 held between (Start date + 24 weeks) and (Start date + 36 weeks) and so on.
Given that each student or individuals start date and end date is different adds another level complexity to it.
I think i just gave you a whole chapter... lol. sorry
