Query help (dates and times)

[StinkFinger]

All,
Struggling with a query here.

table name : holidays
fields : holname (format varchar)
holdate (format date 2004-01-01)

The table is populated with all the holidays for the next 5 years. I am
trying to select only 1 of each holiday for the current year, AND if todays
date is past a holiday for the current year, then select the following years
holiday.

For example, today date would return easter, mothers day, etc. AND next
years valentines (because it is past 2004-02-14).
Does this make sense ?

Many thanks for any help.

[News]

select holname,holdate from holidays where holdate <= date_add(curdate(),
interval 364 day);

"StinkFinger" <st****@pinky.com> wrote in message
news:10*************@corp.supernews.com...

All,
Struggling with a query here.

table name : holidays
fields : holname (format varchar)
holdate (format date 2004-01-01)

The table is populated with all the holidays for the next 5 years. I am
trying to select only 1 of each holiday for the current year, AND if todays date is past a holiday for the current year, then select the following years holiday.

For example, today date would return easter, mothers day, etc. AND next
years valentines (because it is past 2004-02-14).
Does this make sense ?

Many thanks for any help.