Skip to Content
0
Former Member
Mar 31, 2014 at 03:21 PM

how to calculate the number of working days between the two dates based on the calendar table.

694 Views

I have two dates : Release date and action plan complete date. Both coming from the same table

I need to find the number of Working days between these two dates ,based on a calendar table , but this table is in another universe...the only way I can pull the table is by using a separate query.

Example :
Release date : 3/21/2014
Action plan date : 3/28/2014

No. Of business days : 6 days

Calendar table in another universe has all dates from 2007 to 2018 and a flag for holidays. The holiday flag 1 if its a holiday and 0 if it is a working day.

Please help to figure out how to calculate the number of working days between the above two dates based on the calendar table.