Date Ranges [modified]
-
I'm having a little bit of brain fry going on... How can I go about to see if any date within a date range is in another date range? Example: Is any date between 01/01/2008 - 12/31/2015 in 11/21/2008 - 12/21/2009? MOD: Ok, so I think I found my answer. Does anyone see an issue with this comparison? 01/01/2008 < 12/21/2009 AND 12/31/2015 > 11/21/2008 [obviously these would be parameters and fields in a database.... paramStart < dbEnd AND paramEnd > dbStart]
modified on Monday, December 1, 2008 3:09 PM
-
I'm having a little bit of brain fry going on... How can I go about to see if any date within a date range is in another date range? Example: Is any date between 01/01/2008 - 12/31/2015 in 11/21/2008 - 12/21/2009? MOD: Ok, so I think I found my answer. Does anyone see an issue with this comparison? 01/01/2008 < 12/21/2009 AND 12/31/2015 > 11/21/2008 [obviously these would be parameters and fields in a database.... paramStart < dbEnd AND paramEnd > dbStart]
modified on Monday, December 1, 2008 3:09 PM
mobius111001 wrote:
Is any date between 01/01/2008 - 12/31/2015 in 11/21/2008 - 12/21/2009?
If
date1 = 01/01/2008
date2 = 12/31/2015
date3 = 11/21/2008
date4 = 12/21/2009then it would be something like:
... date1 between date3 and date4
or date2 between date3 and date4
or (date1 < date3 and date2 > date4) ...The need to optimize rises from a bad design.My articles[^]