how can i create working days

baskaran chellasamy

14y2.2k

Hi friends,
please give me an idea on how to design working day details. In my task I want to create table for working days to school. this days except with general holidays and sunday as a holiday. i searched for this in google but i didnt get what i want. please help me and let me know any articles related with this title.
thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akkiraju Ivaturi14y ago
You can use the following T-SQL scrip to calculate the number of business days between two dates. Business days usually are defined as non-weekend days. Popular responses include loops or temporary tables. But here is a single-expression approach that does the job.

DECLARE @DateOld datetime, @DateNew datetimeSET @DateOld = '10-Sep-2005'SET @DateNew = GETDATE()
SET DATEFIRST 1
SELECT DATEDIFF (day, @DateOld, @DateNew) - (2 * DATEDIFF(week, @DateOld, @DateNew)) - CASE WHEN DATEPART(weekday, @DateOld + @@DATEFIRST) = 1 THEN 1 ELSE 0 END - CASE WHEN DATEPART(weekday, @DateNew + @@DATEFIRST) = 1 THEN 1 ELSE 0 END
Javeed M Shaikh14y ago
you can do this yourself and that way will have more control on which days you want to define working days.

DateTime dt = new Datetime(today);

if (dt.DayOfWeek == DayOfWeek.Thursday Or dt.DayOfWeek == DayOfWeek.Monday ......)
{
// it is working day
}
else
{
// it is a holiday
}

also in SQL Server

select datename(dw,getdate()) --Friday

select datepart(dw,getdate()) --6