Date problem

scialom

Hi I have 2 dates:

$date1 = '2004/05/20'
$date2 = '2004/06/01'

I need to calculate how many working days are between of them. Is it possible?

thanks,
Assaf

TheDefender

Yes it is possible...
You should look in the PHP manual at the date(), mktime() and strtotime() functions, and you should be able to figure it out...

The easiest way is to convert the dates to a UNIX timestamp (seconds since the epoch) and subtract one from the other. This gives you seconds difference. Then you can just do some simple math to convert it to the difference in days, hours, weeks, whatever...

Sorry, I don't have my snippet library available to post some code, but the functions I referenced above, along with the hint I gave, should get you started.

drawmack

Defender, he wants working days not just days. But this should do it.

<?php
/*int*/ function working_days_between($start,$end,$weekend = array('sat','sun')) {
    $months     = array('January','February','March','April','May','June','July','August','September','October','November','December');
    $weekend    = array('sat','sun');
    $date_ary   = explode('/',$start);
    $start      = $months[intval($date_ary[1])-1] . ' ' . $date_ary[2] . ', ' . $date_ary[0];
    $date_ary   = explode('/',$end);
    $end        = $months[intval($date_ary[1])-1] . ' ' . $date_ary[2] . ', ' . $date_ary[0];
    $start_time = strtotime($start);
    $end_time   = strtotime($end);

$i = 0;
while($start_time < $end_time) {
    if(!in_array(strtolower(date('D',$start_time)),$weekend)) {
        $i++;
    } //end if
    $start_time = $start_time + 86400;
} //end while

return $i;
} //end working_days_between
?>

TheDefender

What drawmack, you mean you don't work 7 days a week like I do? Heck, if you just work 7, you don't need all that extra fancy-schmancy code anyhow... LOL!

drawmack

actually I'm currently working on a machine that will slow the earth's orbit so we can have 8 days a week

TheDefender

WooHoo, sign me up for the Beta Test!

scialom

Hi,

I tried this function and it works fine when the start date and the end date are on the same month. But when they are not I get wired results:
the end unix time is smaler then the start:
June 2004, 23(1858636800) - July 2004, 01(1167004800)

Any ideas?

Thanks,
Assaf