Suppose I have a date range:
15/09/2010 - 25/09/2010
my user will provide another date range for example: 17/09/2010 - 22/09/2010
I want to check that user provided date range is within my date range.
Checking works if both of user provided dates are between my range. But I need to check if one of user provided date is in my date range and another is out of my date range. For example:
07/09/2010 - 22/09/2010
17/09/2010 - 27/09/2010
Here 22/09/2010 is in my date range and 17/09/2010 is also in my range.
I need to write a sql query that check user dates are in my dates.
Any help will be appritiated.
View Complete Post