Hey guys,
I need to create a query that will allow me to calculate MTBF. For this I need to be able to extract holidays and weekends from the total business days to date.
Im working on a query that so far has todays date, dates and details in which online incidents occured and a seperate table for holidays.
How do I come up with total business days (mon-fri) and then extract holidays?
Heres how I think the calculation should work...
Todays date - First buss. day - holidays - weekends = total business days to date.
Then I can take that total divide it by total #of incidents and get my current MTBF.
Any help will be appreciated!!!!!!!
I need to create a query that will allow me to calculate MTBF. For this I need to be able to extract holidays and weekends from the total business days to date.
Im working on a query that so far has todays date, dates and details in which online incidents occured and a seperate table for holidays.
How do I come up with total business days (mon-fri) and then extract holidays?
Heres how I think the calculation should work...
Todays date - First buss. day - holidays - weekends = total business days to date.
Then I can take that total divide it by total #of incidents and get my current MTBF.
Any help will be appreciated!!!!!!!
