Date

Question

hiiii

My web application is of Payroll System

Question: I have to check how many Leaves employee has taken, but organization has 1st and 3rd and in some cases 5th Saturday working. Now my question is if employee has taken leave on First Saturday then that should also count. But I m unable to check how to check that perticular saturday is 1st, 3rd, or 5th.....

Currently I'm able to find Saturdays and Sundays from Number of leaves but unable to find 1st,3rd,5th saturday...

plz reply

thx in advance

Amruta Kirdat · Answer

heyyy vulpes thx for reply i did something like this.... n its working for (DateTime dtLFrom = dtLeaveFrom; dtLFrom { DayOfWeek d = dtLFrom.DayOfWeek; string strDay = Convert.ToString(d.ToString()); if (strDay == Saturday || strDay == Sunday) { if (strDay == Saturday) { int intYear = dtLFrom.Year; int intMonth = dtLFrom.Month; int intLastDayOfMonth = System.DateTime.DaysInMonth(intYear intMonth); string strLastDayOfMonth = intMonth + / + intLastDayOfMonth + / + intYear; string strFirstDayOfMonth = intMonth + / + 1 + / + intYear; DateTime dtLastDayOfMonth = Convert.ToDateTime(strLastDayOfMonth); DateTime dtFirstDayOfMonth = Convert.ToDateTime(strFirstDayOfMonth); for (DateTime dtLast = dtLastDayOfMonth; dtFirstDayOfMonth { DayOfWeek dowFirst = dtFirstDayOfMonth.DayOfWeek; string strDayFirst = Convert.ToString(dowFirst.ToString()); if (strDayFirst == Saturday) { DateTime dtAllSaturdays = dtFirstDayOfMonth; arrAllSaturdays.Add(Convert.ToString(dtAllSaturdays)); } } } intdays = intdays - 1; } } int intIndex = 0; int c = 0; if (arrAllSaturdays.Count > 0) { for (; c { intIndex = c; } arrSaturdays.Add(arrAllSaturdays[0]); arrSaturdays.Add(arrAllSaturdays[2]); if (intIndex == 4) { arrSaturdays.Add(arrAllSaturdays[4]); } }

Vulpes · Answer

You may find the DateTime extension methods in my article ( http://www.c-sharpcorner.com/UploadFile/b942f9/6714/?ArticleID=0e49f862-eaa7-4cd3-a666-3731b9e05240 ) useful for this and similar problems.

Bryian Tan · Answer

hi I did something like that before. We have to display a banner on the website on Saturday it can be 1st 2nd 3rd 4th 5th of the month. Check it out. http://blog.ysatech.com/post/2009/06/27/How-to-get-the-date-of-a-day-of-a-given-week-number-in-a-month.aspx