[SOLVED] 30 day previous - and date comparisons

[benmay.org]

This part of an application has been driving me round in circles for AGES... Starting to loose it

 

Basically, I pull from DB a date of when something happened..

 

I need to establish if that date is or over 30 days ago...

 

Here is what I have but results keep fluctuating and I don't think it's correct..

 

 

	$StoredDate = "$year-$month-$date";

	$StoredDate = strtotime($StoredDate);

	$nowDate = date("Y-m-d");

	$shift = "-30 days"; 

	$CompareDate = sql_date_shift($nowDate, $shift); 

	$CompareDate = strtotime($CompareDate); 

	if($CompareDate > $StoredDate) { $RequireModule = true; } 

//// Functions

function sql_date_shift($date, $shift)
{
return date("Y-m-d H:i:s" , strtotime($shift, strtotime($date)));
} 

 

[xtopolis]

Will it work for you to have mysql do the work instead by only pulling something older than 30 days?

 

.. "WHERE date_column < DATE_SUB(CURDATE(), INTERVAL 30 DAY)";

 

 

If it needs to be a php solution, let us know.

should work now

[corbin]

if($time1 - $time2 >= 30*24*60*60) {
    //been 30 days
}

 

 

time1/2 being unix timestamps, and time1 being > time2.

[Barand]

or get the age in days from the db

 

SELECT DATEDIFF(CURDATE(), date_column) as ageInDays ...