You are here: Home › How Do I Calculate Business Working Days using SQL?

How Do I Calculate Business Working Days using SQL?

How Can We Help?

Created On
byGavin Green
Print
< Back

Answer

SELECT (DATEDIFF(dd, @StartDate, @EndDate) + 1) -(DATEDIFF(wk, @StartDate, @EndDate) * 2) -(CASE WHEN DATENAME(dw, @StartDate) = 'Sunday' THEN 1 ELSE 0 END) -(CASE WHEN DATENAME(dw, @EndDate) = 'Saturday' THEN 1 ELSE 0 END)
Comments are closed.

This is the legacy version of the XMPro Documentation site. For the latest XMPro documentation, please visit documentation.xmpro.com

Go to New Documentation Site
X