Hi
I have a database containing dates, is it possible to retrieve all dates within a specific year range, then subtract the retrieved dates from today's date?
As for the range, try something like:
SELECT foo FROM bar WHERE YEAR(date_col) BETWEEN 2000 AND 2005
As for the subtraction, look into using MySQL's DATEDIFF() function (assuming you're using MySQL, that is).
