Welcome to WebmasterWorld Guest from 35.171.45.91

Forum Moderators: ocean10000

Message Too Old, No Replies

Classic ASP Event Calendar

How can I provide event replication on the same day each month?

     
2:59 am on Sep 20, 2008 (gmt 0)

Junior Member

10+ Year Member

joined:June 21, 2005
posts: 60
votes: 0


I have been developing an event calendar for our Intranet and ran into a snag this afternoon.

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.

Thanks,

Casey