我需要知道一周的第一天和最后一天的日期,知道星期数。
我得到一个开始日期和一个结束日期,代表一个选定的星期的第一天和最后一天在给定的一年。然后,我需要获得去年同一周的开始日期和结束日期,以便对一些数据进行图形比较。
我设法根据给定的开始日期和结束日期获得了周号。现在我需要知道前一年同一周的第一天和最后一天的日期。我怎么能最快做到这一点?
编辑:我就是这样得到周号的:
private int GetWeekNumber(DateTime date)
{
GregorianCalendar calendar = new GregorianCalendar(GregorianCalendarTypes.USEnglish);
return calendar.GetWeekOfYear(date, CalendarWeekRule.FirstDay, DayOfWeek.Sunday);
}发布于 2013-11-11 08:29:14
可以使用以下两种方法根据给定年份计算给定周数和开始日期:
// this method is borrowed from http://stackoverflow.com/a/11155102/284240
public static int GetIso8601WeekOfYear(DateTime time)
{
DayOfWeek day = CultureInfo.InvariantCulture.Calendar.GetDayOfWeek(time);
if (day >= DayOfWeek.Monday && day <= DayOfWeek.Wednesday)
{
time = time.AddDays(3);
}
return CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(time, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
}
public static DateTime FirstDateOfWeek(int year, int weekOfYear, System.Globalization.CultureInfo ci)
{
DateTime jan1 = new DateTime(year, 1, 1);
int daysOffset = (int)ci.DateTimeFormat.FirstDayOfWeek - (int)jan1.DayOfWeek;
DateTime firstWeekDay = jan1.AddDays(daysOffset);
int firstWeek = ci.Calendar.GetWeekOfYear(jan1, ci.DateTimeFormat.CalendarWeekRule, ci.DateTimeFormat.FirstDayOfWeek);
if ((firstWeek <= 1 || firstWeek >= 52) && daysOffset >= -3)
{
weekOfYear -= 1;
}
return firstWeekDay.AddDays(weekOfYear * 7);
}然后,您可以通过以下方式获得这两个日期:
// 46
int thisWeekNumber = GetIso8601WeekOfYear(DateTime.Today);
// 11/11/2013
DateTime firstDayOfWeek= FirstDateOfWeek(2013, thisWeekNumber, CultureInfo.CurrentCulture);
// 11/12/2012
DateTime firstDayOfLastYearWeek = FirstDateOfWeek(2012, thisWeekNumber, CultureInfo.CurrentCulture); 增加6天才能结束这一周。
发布于 2014-11-25 10:32:27
这是我的解决办法:
public static DateTime FirstDayOfWeek(DateTime date)
{
DayOfWeek fdow = CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek;
int offset = fdow - date.DayOfWeek;
DateTime fdowDate = date.AddDays(offset);
return fdowDate;
}
public static DateTime LastDayOfWeek(DateTime date)
{
DateTime ldowDate = FirstDayOfWeek(date).AddDays(6);
return ldowDate;
}发布于 2016-01-11 17:12:10
上述方法计算2016年第一周的错误日期。
基于先前答案的固定代码
public DateTime FirstDateOfWeek(
int year,
int weekOfYear)
{
var newYear = new DateTime(year, 1, 1);
var weekNumber = newYear.GetIso8601WeekOfYear();
DateTime firstWeekDate;
if (weekNumber != 1)
{
var dayNumber = (int) newYear.DayOfWeek;
firstWeekDate = newYear.AddDays(7 - dayNumber + 1);
}
else
{
var dayNumber = (int)newYear.DayOfWeek;
firstWeekDate = newYear.AddDays(-dayNumber + 1);
}
if (weekOfYear == 1)
{
return firstWeekDate;
}
return firstWeekDate.AddDays(7 * (weekOfYear - 1));
}加法试验
[TestCase(2016, 1, 2016, 1, 4)]
[TestCase(2016, 2, 2016, 1, 11)]
[TestCase(2016, 52, 2016, 12, 26)]
[TestCase(2014, 1, 2013, 12, 30)]
public void FirstDateOfWeek_ShouldReturnCorrectDay(int year, int weekNumber, int correctYear, int correctMonth, int correctDay)
{
var helper = new DateHelper();
var result = helper.FirstDateOfWeek(year, weekNumber);
Assert.That(result.Year, Is.EqualTo(correctYear));
Assert.That(result.Month, Is.EqualTo(correctMonth));
Assert.That(result.Day, Is.EqualTo(correctDay));
}https://stackoverflow.com/questions/19901666
复制相似问题