How to get which Saturday, Sunday today is in current month

Ankit Kumar

9y865

Hi Friends,

I am working on Human Resources Management project and have been assigned attendance module and i have a scenario where HR department can set a particular day as week-off and they also can set which of that particular day in the month will be declared as week-off eg. 1st Saturday, 2nd Saturday etc.

while working on get attendance module, how would i know which saturday or sunday this is in current month.

please help..

Thanks in advance

2 Replies

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

Ankit Kumar9y ago
Hi @Himanshu

Looks like you didn't pay attention to category i have chosen, and also dodn't read my question, i was asking for solution in sql server and you gave an example in C# and counting satudays will not get my goal achieved, suppose someone has joined from mid of month then, application is not going to count those days.

However Thanks for your reply, i have done it myself, below is my SQL Query:-

if(datename(DW,@date)=='Saturday')
begin

declare @weekoffno int;
select @weekoffno= ((datepart(DD, @date)- 1) / 7) +1;

end
0
Himanshu Gupta9y ago
Hi Ankit,

Use this logic, I think it will help:

int countSaturday=0;
int CuurentDate = Convert.ToInt32(Console.ReadLine());
while (CuurentDate > 0)
{
CuurentDate -= 7;
countSaturday++;
}
Console.Write(countSaturday);

0