Given two date ranges, whether the two date ranges overlap?
As an example, suppose we have ranges denoted by DateTime variables StartDate1
to EndDate1
and StartDate2
to EndDate2
.
eg:
(A) StartDate1- 14-08-2014 EndDate1 - 14-08-2015
StartDate2- 14-08-2012 EndDate2 - 14-08-2013
(B) StartDate1- 14-08-2014 EndDate1 - 14-08-2015
StartDate2- 14-08-2013 EndDate2 - 14-08-2014
(C) StartDate1- 14-08-2014 EndDate1 - 14-08-2015
StartDate2- 15-08-2014 EndDate2 - 13-08-2015
(D) StartDate1- 14-08-2014 EndDate1 - 14-08-2015
StartDate2- 14-08-2015 EndDate2 - 14-08-2016
(E) StartDate1- 14-08-2014 EndDate1 - 14-08-2015
StartDate2- 15-08-2015 EndDate2 - 15-08-2016