Calculation for determinding the $enddate with given $startdate and $numOfDay.Help!!!

[duelist]

Hi, currently i'm developing an application for applying leave.Here what I want to do:

Let say a user want to apply for leave for 3 days from 16/6/2006.

$numOfDay = 3
$startdate = 16/6/2006
$enddate = ???

so I want to know how to get the $enddate.(from above example the result is suppose to be $enddate = 18/6/2006.)

$startdate and $numOfDay will be post to database and also will be obtain from database for the calculation.

I've been looking sort of forums about this and i found the coding something like this:

$date = strtotime($date) + 86400; 

and also this:

$date = date('Y-m-d', strtotime($date . ' +1 day'));

I've change both coding base on my variable.This is the code:

$enddate = strtotime($date) + $numOfDay;

I also change the code to this:

$enddate = date('Y-m-d', strtotime($date_ . ' +numOfDay day'));

It seem not working.I think there something wrong on the coding.Anyone have idea.

Thanks in advance

[nanny79]

Try this:

$enddate = date('d/m/Y',strototime($startdate)+(606024*$numOfDay));

I hope this works for you.

🙂
Regards
Nanny

[duelist]

Thank you nanny79,

$enddate = date('d/m/Y',strototime($startdate)+(60*60*24*$numOfDay));

Now it work.but there still the problem.I'm adding echo code for displaying the date(for testing purpose) here the code:

$enddate = date('d/m/Y',strtotime($start_date)+(60*60*24*$numOfDay));
echo $enddate;

It display the date correctly.

Then,I just modify the code to insert it to database.Here the code:

$enddate = date('d/m/Y',strtotime($start_date)+(60*60*24*$numOfDay));

$date_elem = explode('-',$enddate); 
$end_date = date('Y-m-d', mktime( 0,0,0,$date_elem[1],$date_elem[0],$date_elem[2]) );

//connect to database code 

$sql = "INSERT INTO tarikh (date_, numOfDay, enddate) VALUES ('$start_date','$numOfDay', '$end_date')";

$dbResult = mysql_query ($sql,$db); 

When I check the data base,the day is diaplay correctly but the month and year keep displaying 12/1999........I think the $numOfDay need to be multiply with some more number,but I don't remember the numbers.Anyone have any idea.

Thank you in advance.

[nanny79]

Change
$enddate = date('d/m/Y',strototime($startdate)+(606024*$numOfDay));

to
$enddate = date('Y-m-d',strototime($startdate)+(606024*$numOfDay));

Now the date what you get is the format required for the database.

It will work now.

[duelist]

ok,thank you nanny79,actually I'm just thinking as the same as you are and I change the code.Now it work.

[rosy]

Hi
I would like to do the similar date calculation. for example,
i have to give a date by choosing it from popup calendar and if the user moved to next text box, it should display the date by adding 37 business days.
Here is my code that i tried.

<script >
function calculatedate() {
$unit_billing_date = date("Y-m-d", strtotime('2007-03-01 + 37 days')); //document.form.date - instead of '2007-03-01' 
return $unit_billing_date;
}
</script>
<td align="right"><b>Date Required:</b></td>
<td><INPUT TYPE="text" NAME="date" SIZE="25" CLASS="text" tabindex="3" onChange="calculatedate();"><a href="javascript:showMonth(0, document.validform.date);">
<img border="0" src="pics/sdate.gif" alt="" width="15" height="16"></a>
</td>
<td align="right"><b>Unit Billing Date:</b></td>

 <td><INPUT TYPE="text" NAME="billing_date" VALUE="<?php print $unit_billing_date; ?>"  SIZE="25" CLASS="text" tabindex="4"></td>
</tr>

When i tried, i could not get any results.
please help if i am wrong with coding.
Thanks.

[Roger_Ramjet]

Just do it in the database with sql ADDDATE or DATE_ADD function.

$sql = "INSERT INTO tarikh (date_, numOfDay, enddate) VALUES ('$start_date','$numOfDay', ADDDATE('$start_date' INTERVAL '$numOfDay' DAY)";

[nanny79]

Rosy,

Actually you are trying to show the date in the form first. But how you are getting the value for $unit_billing_date with out calling the function. And in the function, you need to change the the code like this

function calculatedate() {
$unit_billing_date = date("Y-m-d", strtotime('2007-03-01') + (37 24 60 * 60));
return $unit_billing_date;
}

[rosy]

Hi nanny,
Actually i am taking the date from popup calendar. If i select the date from the popup calendar and click on the next text box, it should calculate the date by adding 37 days to the selected date. So how do i make it in the function?

function calculatedate() {
$unit_billing_date = date("Y-m-d", document.date.value + (37 * 24 * 60 * 60)); 
return $unit_billing_date;
}

please help.

[nanny79]

Rosy,

If you are getting the date from a calendar pop-up, then in the post method call your function by passing the date

like this

function calculatedate($dt) {
$unit_billing_date = date("Y-m-d", strtotime('$dt') + (37 24 60 * 60));
return $unit_billing_date;
}

$dbdate = calculatedate($_POST['billing_date']);