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?

For that we usually break date as day/mon/year and subtract.
Any more methods ?

This depends entirely on the format which the date is stored.

if its stored in date soemthing like

 WHERE date > 2008-01-01 AND date < 2008-12-31

would select all dates from this year.

then

PHP Code:

while(row fetch... )
{
echo date('Y-m-d') - $row['date'];
} 


would create a list of all the dates from this year, minus todays date.

TP apprieciated
Dan