I have code like this
Calendar calendar = CultureInfo.CurrentCulture.Calendar; int weekNo = calendar.GetWeekOfYear(DateTime.Now, CalendarWeekRule.FirstFullWeek, DayOfWeek.Tuesday); var tempResultsult = from p in db.Laporan where p.TanggalLapor.Year.ToString() = DateTime.Now.Year.ToString() && (calendar.GetWeekOfYear(p.TanggalLapor, CalendarWeekRule.FirstFullWeek, DayOfWeek.Tuesday)).ToString() = weekNo select p;