Thanks for coming back. Can your IT department either write the report for you. Querry400 will not allow you to use the calendar file on a join with a date range.
Register Hereor login if you are already a member
This is difficult to do with QUERRY400.
You could get the number of days between the date range and then div by 7 to get the number of weeks. Multiple that by 2 and get the number of weekend days. Subtract that from the total days.
But that does not account for when there is a reminder with the divide instruction and you do not know if the day of the week of the first date in the range.
Also you have nothing to compare with to find out if there are any holidays within the range (and the day of the week the holidays fall on).
Can you use any other language?
Can you give us the business application for this task?
Have you approached anyone in your IT department?
Do you have experience with EXCEL?
Check with you IT department to see if they can assist you.
Else do a data extract with excel and then you can use a function to get the number you want,
You are very welcome.
If/when you get the results you are looking for, please come back and update us with hoe it was done.
Does the calendar file have a running day of the year column.
It's not very likely but I can't begin to figure how to do this in query without it.