Conditional Testing Glitch

G

Guest

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
 
G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top