Dates - older than one year old

[JonathanAnon]

Hi

I have a piece of SQL code to pull out records that are only one year old
$sql= "SELECT * FROM projects WHERE DATE_SUB(CURDATE(),INTERVAL 365 DAY) <= '$currentdate';";

But how do I get records that are older than one year ??
I have tried the opposite sign but it will not work.

regards,
Jonathan.

[a2bardeals]

i don't know your date format in SQL but if it's DATE and not TIMESTAMP then you could try something like:

$oneyearago = date('Y-m-d', mktime(0, 0, 0, date('Y') - 1, date('m'), date('d')));
$twoyearsago = date('Y-m-d', mktime(0, 0, 0, date('Y') - 2, date('m'), date('d')));

$sql= "SELECT * FROM projects WHERE DATE_SUB <= '$oneyearago' && DATE_SUB >=$twoyearsago' ;";

[fenway]

I don't understand -- just add a year to the desired date, and see if it's still not "now":

e.g. WHERE CURDATE() > DATE_ADD( '$currentdate'. 365 DAY )