Re: [SQL] Calculate next event date based on instance of the day of week

2010-12-02 Thread Jayadevan M
Hello, > I have a table which stores an event date. The event is stored as a > standard mm/dd/yy entry. > > I then need to calculate based on the dd value, WHICH day of the > week that is (e.g. Wednesday) and which occurrence of that day of > the week, within the month, it is (e.g. the THIRD We

[SQL] Calculate next event date based on instance of the day of week

2010-12-02 Thread Dimitri
I'm sure the subject sounds extremely confusing :) I have a table which stores an event date. The event is stored as a standard mm/dd/yy entry. I then need to calculate based on the dd value, WHICH day of the week that is (e.g. Wednesday) and which occurrence of that day of the week, within the