[Resolved] Getting the date... x working days ahead

tero

Hello there,

Im trying to come up with a script that, given a starting working date and the number of working days required, returns me the corresponding final working date.

I have tried a lot of different approches but cant seem to get it working.

Any help will be appretiated.

Thanks in advance.

nemonoman

$answer=strtotime("$workingdate + $somenumber days");

tero

Thank you very much nemonoman,

I cant belive how simple it was.. I had done a 30 lines function and still wasnt working, you can imagine, I feel like a small little newby.

Thanks again.

Tero

nemonoman

I felt exactly the same when someone on this forum gave me this very advice about a year ago.

Don't forget to mark your thread resolved.

tero

nemonoman,

I´ve tryed de code you gave me and it doesnt appear to be working right.

for($i=0;$i<21;$i++)
{
echo $answer=date('m/d/Y',strtotime("today + $i days"));
echo "<br>";
}

This gives me all the days from now to 21 days ahead but counting weekends. What i was trying to do should give me 21 ahead but skiping weekends.. in other words the real, final date should be more than 21 days from today.

any ideas?

Thaks in advance.

drawmack

hmm you'll have to do a little funky scripting:

<?php
    function calc_working_date($start,$num) {
        $months = array('January','February','March','April','May','June','July','August','September','October','November','December');
        $date_ary = explode('-',$start);
        $start = $months[intval($date_ary[0])-1] . ' ' . $date_ary[1] . ', ' . $date_ary[2];
        $start_time = strtotime($start);

    $cur_time = $start_time;
    $i = 0;
    while($i < $num) {
        if(date('D',$cur_time) != 'Sat' && date('D',$cur_time) != 'Sum') {
            $i++;
        }
        $cur_time = $cur_time + 86400;
    } //end while

    $retval = date('n-d-Y',$cur_time);
    return $retval;
} //end calc_working_days
?>

nemonoman

echo "21 weekdays from ".date ("d F Y")." is ". date ("d F Y", finishdate(21));

21 weekdays from 18 June 2004 is 19 July 2004

function finishdate($weekdaysToWork,$startdate){
    if(!$startdate){$startdate=strtotime("today");}
    while($weekdays<$weekdaysToWork){
        $count++;
        $weekdays+=(date ("D",strtotime(date ("d F Y",$startdate) ."+ $count days"))!='Sat' && date ("D",strtotime(date ("d F Y",$startdate)."+ $count days"))!='Sun');
    }
    return strtotime(date("d F Y",$startdate)." + $count days");
}

funky spacing added by PHPBuilder

nemonoman

didn't see drawmack's answer when I posted

tero

nemonoman,

That was exactly the thing i was looking for. It works great. The only thing i touched was taking the total number of working days -1 to count for the first day too. It seems to be working just as i wanted.

Thank you very much.