Re: Get date for floating holiday, ie Thanksgiving

I meant more along the lines of month=11 and day=thursday and week=last...(this is assuming I've already determined the holiday's timing according to the locale)

month and day are easy but what about the 'last week'? the last thursday of the month could equate week=4 or week=5 depending on the day the month started on.

Obviously some PL/SQL could do this, but I was hoping there was a straight forward method.

Thanks,

 Kathleen

In article <395C871A.30D9CFF7_at_iquest.net>,   David Van Zandt <dvanzandt_at_iquest.net> wrote:
> If you mean something like "select x from dual where holiday =
> Thanksgiving", no. A good question; but bear in mind you'd have to
 have
> some huge effort to track such holidays for EVERY country. Or if an
> atheist demanded exclusion of all religious holidays? Or if we
 included
> all holidays for all religions? AARRGH!
>
> Then there are the state holidays, and congressional designations (why
> Fathers' Day, but not National Pickle Day).... But I digress <grin>.
>
> Or did you mean something more like selecting month = 06 and week = x
> and day = y?
>
> kathleen_at_mysimon.com wrote:
> >
> > Hello All,
> >
> > Is there a way to query for the date of a floating holiday for the
> > current year? For example:
> > Thanksgiving is always the last Thursday in November
> > Father's Day is the second Sunday in June
> >
> >
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CEST