mysql 1 yr interval

[dreams4000]

Hi all,

I am trying to display items that have a date that falls in a month that is one year past the current date.. ie if it was added last june, and this month is june, I want to show last June's items. The date is stored as 2004-06-20.

The Where statement looks like:

$tmpquery = "WHERE mem.profil IN(2,11,12,13) AND (mem.cstart = (CURDATE() - INTERVAL 12 MONTH)) ORDER BY $block1->sortingValue";

but it doesn't seem to call anything no matter what month # I set. Any ideas? mem.cstart is the 2004-06-20 date or whatever other date.

[nemonoman]

Your query will only return records that are precisely 12 months older than the current date.

You want the records for the comparable year ago month?

WHERE date_format(memstart,'%Y%m')=date_format(CURRENT_DATE()-INTERVAL 12 MONTH,'%Y%m')

would return all records for June 2003

[dreams4000]

Rockin! that worked like a charm. Thanks for the help on this.

[nemonoman]

don't forget to mark thread "resolved"