Recent content by ndindi22

Hi guys This is what i've SELECT (DATEDIFF(dd, ContractStartDate, ContractEnddate) + 1) -(DATEDIFF(wk, ContractStartDate, ContractEnddate) * 2) -(CASE WHEN DATENAME(dw, ContractStartDate) = 'Sunday' THEN 1 ELSE 0 END) -(CASE WHEN DATENAME(dw, ContractEnddate) = 'Saturday' THEN 1 ELSE 0 END)...

Hi guys Please help me with a function to calculate number of days between startdate and enddate excluding weekends. This is leave application where an employee get 1 day leave every after 17 days from the start date of contract. and the leave the accrue by 1 every after 17 days. I'm using...