[SOLVED] Subtracting Dates

[Bendude14]

Can someone point me in the right direction for subtracting one date from another

 

11/08/2008 - 05/04/2008 = Number of days between these two dates? eg 128 days

[bluejay002]

If you are not to do it SQL, then you can do it by converting both dates to a timestamp, then deduct then convert into days.

 

example:

 

<?php
$date1 = '2008-02-05';
$date2 = '2008-03-05';
$secsInDay = 60 * 60 * 24;

$secsInterval = strtotime($date2) - strtotime($date1);
$daysInterval = $secsInterval / $secsInDay;

echo $daysInterval;
?>

[Bendude14]

Thanks for that i will give it a go.

 

I do have SQL available if there is an easier way using the database?

 

ben

[bluejay002]

definitely... and i do recommend it than using PHP for this kind of stuff. this is possible using DATEDIFF()

 

example:

 

... DATEDIFF(field_date_one, field_date_two) ...

 

the result will always be in days

 

jay,

[Bendude14]

Thanks just what i needed

 

Ben

[bluejay002]

your welcome