Can anyone point me in the right direction? I'm trying to find out how many days fall in a particular range. If I have a booking date range for example '18 Jan 2013 21:00' and '4 Feb 2013 15:00' and want to know how many days fall between 1st Feb and 30th of April. After lots of fiddling I may have it..?
/* The test date range */
var startTime = "18 Jan 2013 21:00";
var endTime = "4 Feb 2013 15:00";
/* Set up the range to test against*/
var rangeStart = Date.parse ("1 Feb 2013 00:00");
var rangeEnd = Date.parse ("30 Apr 2013 00:00");
var start = Date.parse(startTime);
var end = Date.parse(endTime);
var numOfHrs = Math.ceil((end-start) / (1000*60*60));
var numOfDays = Math.ceil(numOfHrs/24);
var rangeCrossed = 0;
if (end > rangeStart){ /* A valid crossover period may exist */
/* Start time before or equal range start and end less than or equal the range end */
if ((start<=rangeStart) && (end <= rangeEnd)) { rangeCrossed = end-rangeStart }
/*Start greater than or equal to the range start and less than the range end */
else if ((start>=rangeStart) && (start<rangeEnd))
{
/* start and end both within range */
if (end<=rangeEnd) { rangeCrossed = end-start }
/* start after range start and end after range end */
else {rangeCrossed = (rangeEnd-start) + (end-rangeEnd)};
}
/*full range crossed */
else if (start<=rangeStart && end >=rangeEnd) { rangeCrossed = rangeEnd-rangeStart};
}
alert((rangeCrossed/(1000*60*60)/24))