Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: ocean10000
We have several meetings that take place on the same day each month (the 3rd Wednesday, the last Friday, etc) and I would like to be able to replicate the events in the database with ease for my users.
However, I can't seem to come up with a reliable way to get the dates for the events in the future months. The case that keeps killing my ideas is a meeting that takes place on the last Wednesday of each month. I've tried adding 4 weeks with dateadd and then adjusting the results to accomodate the calendar changes, but I can't seem to get it right.
Any help would be appriciated.