0

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))
cweiske
  • 30,033
  • 14
  • 133
  • 194

0 Answers0