Re: getting a date 25 years back

Richard Lynch wrote:

Merlin wrote:

I am trying to create a date which is 25 years back from today. The purpose of this is to be able to query a mysql database "date" field for columns smaller than this date. I tried this: $years = 25;

//> $start_from = date("Y-m-d",strtotime("- ".$years." year"));

Somehow it always ads the years instead of subtracting. Has anybody an idea on how to do that?

You can do this in all MySQL: select ... where date_field <= sub_date(now(), interval 25 years) Or you could try: $back_then = mktime(0, 0, 0, date('m'), date('d'), date('Y') - 25); $start_from = date("Y-m-d", $back_then);

thank you everybody for your help. I used this which works excellent: $back_then = mktime(0, 0, 0, date('m'), date('d'), date('Y') - 25); Thanx, Merlin