[SOLVED] subtracting date's

[nathanmaxsonadil]

I was wondering how to subtract a date(like I have 2007-10-05 and I want it to subtract 5 days)?

[GingerRobot]

You need to first convert your date into a timestamp, then take off the required number of seconds, then convert your timestamp back to whatever format you wanted. Try:

 

<?php
$date = '2007-10-05';
$timestamp = strtotime($date);
$new_timestamp = $timestamp - 60*60*24*5;
$new_date = date('Y-m-d',$new_timestamp);
echo $new_date;
?>

[nathanmaxsonadil]

thanks

[BlueSkyIS]

or...

 

$date = '2007-10-05';
$parts = explode("-",$date);
$fivedaysago = mktime(0,0,0,$parts[1],$parts[2] - 5, $parts[0]); // as timestamp
$fivedaysago2 = date("Y-m-d",$fivedaysago); // As 'YYYY-MM-DD'

[GingerRobot]

or...

 

$date = '2007-10-05';
$parts = explode("-",$date);
$fivedaysago = mktime(0,0,0,$parts[1],$parts[2] - 5, $parts[0]); // as timestamp
$fivedaysago2 = date("Y-m-d",$fivedaysago); // As 'YYYY-MM-DD'

 

True, though i personally avoid using the mktime function on principle. I dont know of another function where the parameter order is so completely unintuitive!

[BlueSkyIS]

yep, i had to look up the order for month, day, year. 

 

i like mktime more for the month and year math capabilities. mktime helps prevent me worrying about whether yesterday was a leap day or a daylight savings time change...