Getting date for next day of week
I have a table of delivery dates for customer companies, set up with checkbox fields for Mon - Fri. Also a table of holidays with specific dates (7/4/2004, etc.). I need to calculate the next delivery date; for instance if today is Friday and delivery dates are Mon, Wed, and Fri then the next delivery day would be Mon. Can't figure out how to get the date of the next delivery day. Not all companies would have the same delivery days and not all companies would have the same number of deliveries per week. Also, if the next delivery date falls on a holiday, as entered in the holidays table, then that delivery day would move to the next delivery day. I can't seem to get a handle on this. Does anybody have any ideas?