Let's say I have a database with fields "Start_Date", "End_Date" and "Duration".

I have another database of holidays with a field called "Holiday_Date"

Is it possible to find the number of holidays between the start and end dates WITHOUT using a script, but using only relationships and calculations.

I solved the problem with a script that sets a global field to all of the dates between start date and end date (separated by returns) and counts the number of records related in the holiday file. So if I can find a way to fill in that field without a script, that would also solve the problem.

Thanks,

Chuck

Well, I solved this problem but the calculation is HUGE. Perhaps someone else would benefit from knowing it, or perhaps someone else will know of a better calculation.

Here's the calc so long as the date range is less than 15 days:

Start_Date & "