A date interval with a date interval query
I'm trying to figure out a query that will return records if any dates between 2 user entered dates fall with a date range stored in the db. Lets say the 2 user dates are called UDate1 and UDate2 and the db date range is called DDate1 and DDate2. Any date between UDate1 and UDate2 must match any date between DDate1 and DDate2. This all needs to be done with a query.
|