How can I compare dates to see if it is "open", booked or a holiday?
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.