Jump to content


Photo

Date subtraction


  • Please log in to reply
2 replies to this topic

#1 snowdog

snowdog
  • Members
  • PipPipPip
  • Advanced Member
  • 107 posts

Posted 05 July 2006 - 07:43 PM

I have been trying to find out how to calculate in a numerical form the number of days bewteen two dates.

i tried and get an answer of 0. How can i convert the date into a number?

So basically I will have two dates, Todays date and a date stored in a database that I will retrieve Do the math and if the difference is 0-30 i do nothing, 30-34 i do one thing, 60-64 i do another another and greater than 64 i do nothing.

<code>
<?
$date1 = date("Y-m-d");
$date2 = date("Y-m-d", strtotime("+2 days"));

$date_diff = $date2 - $date1;

echo $date_diff;
?>
</code>

Thanks,

Snowdog

#2 kenrbnsn

kenrbnsn
  • Staff Alumni
  • Advanced Member
  • 8,235 posts
  • LocationHillsborough, NJ, USA

Posted 05 July 2006 - 07:58 PM

The code you have now is trying to subtract strings, not numbers. The time(), mktime(), and strtotime() functions will all return the number of seconds since 1-1-1970.

Your example would then be:
<?php
$date1 = time();
$date2 = strtotime("+2 days");
$date_diff = floor(($date2 - $date1)/86400);
echo $date_diff;
?>

Ken

#3 snowdog

snowdog
  • Members
  • PipPipPip
  • Advanced Member
  • 107 posts

Posted 05 July 2006 - 08:28 PM

Thanks, I was not thinking about time, i was thinking about it as number of days, which your formula does switch it over to.

Snowdog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users