Date Range located inside of a date range

[thechazm]

I have a mind boggling logic problem that I just can't seem to put my finger on what to do...

I am trying to find all training that is happening during the period of one week. While I have been able to get this to work with using a between statement there is still a problem where it does not include all personnel in training.

Here's the example:
If I wanted to see who was in training from 8/27/2012 To 8/31/2012.
Each class has a Start and an End date.

Here's the personnel data:
Name: Joe
Start: 8/28/2012
End: 8/29/2012

Now this guy I can get it to return because his start date and his end date are between the two dates because its only a 1 day long class.

But for this guy:
Name: Crump
Start: 8/24/2012
End: 9/4/2012

He is in training for the time frame I want to look at but by just using the between operator for the specified dates above this guy would never show up even though he's in training all that week.

How should I look at this logically to be able to include anyone that is in training during that date time frame?

Thanks,

TheChazm

 

[Brianwarnock]

Pbaldy a poster here has answered this and I think that you can find the answer on his baldyweb,,google this as I cannot remember the full link.

Brian

 

[Brianwarnock]

It's just

http://www.BaldyWeb.com/

Brian

 

[thechazm]

Ahh thanks exactly what I was looking for!