AnsweredAssumed Answered

How can I compare dates to see if it is "open", booked or a holiday?

Question asked by BruceBono on Sep 23, 2010
Latest reply on Sep 23, 2010 by philmodjunk

Title

How can I compare dates to see if it is "open", booked or a holiday?

Post

I have a small school. Many tables and relationships. One table, called School Dates is set up to type in dates that are school/state holidays. I have another table called Classes. I would like to be able to have a script that will "expand" the class into a chosen number of classes, with the dates....like one class every Wednesday for 30 times....AND have it compare the classes dates with the School Dates...to avoid holidays...when I schedule.

I have the script working as far as expanding the one class into multiple, but I cannot figure out how to make the date problem described above to work.

Thank you for reading and I hope there is enough information for you to clearly understand.

Outcomes