[Resolved] Compare dates

cbrknight

I have a datestamp in Y/m/d format that is stored in database of when a client signed up for a trial membership.

I need to compare that date with today's date

Date(Y/m/d)

and see if there are more then 14 days between the two dates...

How can I accomplish this?

planetsim

Well firstly you could do a search.

Secondly something like this should get you started

list($year,$month,$day) = explode("/",date("Y/m/d"));

From there use mktime on both current time and that to get both in an easy format. Then its simple math.

elementaluk

actually try avoid exploding the date then checking each one (day month year), it takes to long to write, its more complicated than dating 3 chicks at the same time and will only cause you problems in the long run.

Instead, take the lazy mans way out with only a few lines of code:

<?php
$w_ago = strtotime("-14 days"); //timestamp of 14 days ago
$w_str = date("Y-m-d",$w_ago); //14 days ago

//I go on to delete from mysql where the date is equal to our -14 one
?>

Ok now if you run this once a day, every day, it should do the trick or you can go on to advance it.
You should look into strtotime(), date(), time() and mktime()

planetsim

Must have been the painkillers along with some other drugs im currently taking to post that. Anyway there isnt anything wrong with exploding (i was going to actually use the mktime method so there would be only a timestamp check) however you can actually skip using PHP altogether really and use a simple SQL statement using the Date Functions that are within MySQL (that is if your using MySQL) http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

cbrknight

I dont know if I am misunderstanding or what... the functions you mentioned will give me the date 14 days ago... but how do I compare that to the date I have to see if the date is greater then 14 days old?

this is what I am working on now...

$today = date("Y-m-d");
$w_ago = strtotime("-14 days");
$w_str = (date("Y-m-d", $w_ago);

$sql = "SELECT * FROM users where $today > $w_str";
$Result = mysql_query($sql, $dbConn) or die("Error: " . mysql_error());
$dbarray = mysql_fetch_array($Result);

$date = $dbarray['datestamp'];
$num = count($dbarray);
for ($=0; $c<$num;$c++){
print "<br>". $dbarray['fName'] . $dbarray['lName'] . $dbarray['datestamp'];
}
print "<br>Number of Matching Records: " . $num;

This outputs:
JohnDoe2005-01-30
JohnDoe2005-01-30
JohnDoe2005-01-30
JohnDoe2005-01-30 etc

Number of Matching records: 24

What am I doing wrong... the date returned is only 4 days from todays date. I need to be sure it is 14 days or more from todays date.