Thursday, April 3, 2014

Get Date from week number

1. Function is created to get date from week number and day of the week



static DateTime GetDateFrmWkNumberAndDayOfWk(int weekNumber, int dayOfWeek)
    {
        DateTime jan1 = new DateTime(DateTime.Now.Year, 1, 1);
        int daysOffset = DayOfWeek.Monday - jan1.DayOfWeek;

        DateTime firstMonday = jan1.AddDays(daysOffset);

        var cal = CultureInfo.CurrentCulture.Calendar;
        int firstWeek = cal.GetWeekOfYear(jan1, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);

        var weekNum = weekNumber;
        if (firstWeek <= 1)
        {
            weekNum -= 1;
        }

        var result = firstMonday.AddDays(weekNum * 7 + dayOfWeek - 1);
        return result;
    }


2. pass week number and day of week to get date



DateTime theDate = GetDateFrmWkNumberAndDayOfWk(6, 1);


No comments:

Post a Comment