[SOLVED] Age range based on Data of Manufactor

[Canman2005]

Hi all

 

I have a bunch of records which have a date field `datecreated` next to each one, so for example

 

2003-09-28

 

these are dates that products are built (manufactor)

 

I want to do a QUERY which would grab all records that the date of manufactor was between x and y years.

 

So grab all records which have a manufactor date of between 10 and 15 years old

 

Is that possible or should I store the date next to each item?

 

Thanks so much everyone

 

Dave

[JonnoTheDev]

SELECT * FROM tablename WHERE datecreated >= DATE_SUB(CURDATE(), INTERVAL 15 YEAR) AND datecreated <= DATE_SUB(CURDATE(), INTERVAL 10 YEAR)

[Canman2005]

thanks man