I need to get dates from a Holiday List Table so that the system will show which dates match the range of dates in the week of production.
I have a Production Table where the intened Week of Production (WeekOfFiscalYear) is set by the planner.
eg Week 19 :Starts on Monday(WeekStartDate) 02/05/2011 and ends on Friday 06/05/2011
Monday Tuesday Wednesday Thursday Friday are separate date fields which are based on the Week Start date + one day for Tuesday ,+ 2 for Weds etc
I have another related table HOLIDAYS which lists all holidays for the year.
If for example Tuesday 03/05/2011 is a Holiday I want the Tuesday field to be show "Holiday".
The problem is that I cannot seem to get the calculation to do this for a range of days.
Once the week of production has been set I want the system to go to the Holiday list , check if there are any Days/dates in the week of production that are equal to any of the week days within that week of production and then to alert.
Hope I have mader it clear.
Thanks in advance