I have a table with Dates (table1) which we are putting the days throughout the year that our shop will be closed. We are adding to this table as we find out when the shop will be closed so it will be changing continuously.
I would like to compare this field in table1 to see if its greater than a start date on table2 and less than an end date on table2 (table2 is our ERP scheduling table). If its between this range I want to display a notice that the shop is closed. The other kicker is that the tables are not linked because table1 only has a few days in it.
Assuming this will be some kind of If then statement but not sure how to compare the data from one table to another when they are not linked.
Any help is appreciated!