I have two start / stop day ranges associated with variables.
1’st day range:
bVa = 83 (start)
bVb = 116 (stop)
2’nd day range:
tVa = 151 (start)
tVb = 181 (stop)

I’m trying to test for overlap between the first and second day range and if
that overlap is greater than say 7 then I have in place what should happen.
Currently I’m just trying to just meet the simpler condition; is there
overlap between the two day ranges but am stuck in thought and diagram…

Appreciatively,
Arturo

Not positive I understand the problem, but it looks like you just want to
find out if the second days range falls into the first days range. If that is
true then overlap can be checked by subtracting tVa-bVb. this will tell you
what is between the end of the first day and the start of another. In your
case the answer is 35, if it is ever <0 then you have overlap, if you want to
check for say 7 digits of overlap its just if it is <=-7. Hope that is what
you needed.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Arturo" wrote:

> I have two start / stop day ranges associated with variables.
> 1’st day range:
> bVa = 83 (start)
> bVb = 116 (stop)
> 2’nd day range:
> tVa = 151 (start)
> tVb = 181 (stop)
>
> I’m trying to test for overlap between the first and second day range and if
> that overlap is greater than say 7 then I have in place what should happen.
> Currently I’m just trying to just meet the simpler condition; is there
> overlap between the two day ranges but am stuck in thought and diagram…
>
> Appreciatively,
> Arturo

This didn't hit it it exactly - my bad for not articulating the glitch
clearly...

"John Bundy" wrote:

> Not positive I understand the problem, but it looks like you just want to
> find out if the second days range falls into the first days range. If that is
> true then overlap can be checked by subtracting tVa-bVb. this will tell you
> what is between the end of the first day and the start of another. In your
> case the answer is 35, if it is ever <0 then you have overlap, if you want to
> check for say 7 digits of overlap its just if it is <=-7. Hope that is what
> you needed.
> --
> -John
> Please rate when your question is answered to help us and others know what
> is helpful.
>
>
> "Arturo" wrote:
>
> > I have two start / stop day ranges associated with variables.
> > 1’st day range:
> > bVa = 83 (start)
> > bVb = 116 (stop)
> > 2’nd day range:
> > tVa = 151 (start)
> > tVb = 181 (stop)
> >
> > I’m trying to test for overlap between the first and second day range and if
> > that overlap is greater than say 7 then I have in place what should happen.
> > Currently I’m just trying to just meet the simpler condition; is there
> > overlap between the two day ranges but am stuck in thought and diagram…
> >
> > Appreciatively,
> > Arturo