Chuck Posted October 25, 2000 Posted October 25, 2000 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
Chuck Posted October 26, 2000 Author Posted October 26, 2000 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 & "
Recommended Posts
This topic is 9047 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now