Get the correct week number of a given date

by

As noted in this MSDN page there is a slight difference between ISO8601 week and .Net week numbering.

You can refer to this article in MSDN Blog for a better explanation: “ISO 8601 Week of Year format in Microsoft .Net”

Simply put, .Net allow weeks to be split across years while the ISO standard does not.
In the article there is also a simple function to get the correct ISO 8601 week number for the last week of the year.

Update The following method actually returns 1 for 2012-12-31 which is correct in ISO 8601 (e.g. Germany).

// This presumes that weeks start with Monday.
// Week 1 is the 1st week of the year with a Thursday in it.
public static int GetIso8601WeekOfYear(DateTime time)
{
    // Seriously cheat.  If its Monday, Tuesday or Wednesday, then it'll 
    // be the same week# as whatever Thursday, Friday or Saturday are,
    // and we always get those right
    DayOfWeek day = CultureInfo.InvariantCulture.Calendar.GetDayOfWeek(time);
    if (day >= DayOfWeek.Monday && day <= DayOfWeek.Wednesday)
    {
        time = time.AddDays(3);
    }

    // Return the week of our adjusted day
    return CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(time, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
}

More Related Contents:

  1. Working of page at background without restricting navigation of other pages in asp.net [closed]
  2. save data from 2 forms and show it in a 3rd form c# [closed]
  3. Days between two dates in asp.net
  4. Finding the variable name passed to a function
  5. Fire and forget async method in asp.net mvc
  6. Difference between RegisterStartupScript and RegisterClientScriptBlock?
  7. Object cannot be cast from DBNull to other types
  8. The type is defined in an assembly that is not referenced, how to find the cause?
  9. How can I get a list of users from active directory?
  10. Has an event handler already been added?
  11. How to set session timeout in web.config
  12. Finding all positions of substring in a larger string in C#
  13. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  14. How to Get IP Address?
  15. EPPlus number format
  16. How to show a image in database in the image control of Asp.net?
  17. How DataReader works?
  18. Can I have an optional parameter for an ASP.NET SOAP web service
  19. How to use custom Authorize attribute for roles as well as a specific user?
  20. Check ssl protocol, cipher & other properties in an asp.net mvc 4 application
  21. Upload file on FTP
  22. Overloading getter and setter causes a stack overflow in C# [duplicate]
  23. Printing from ASP.NET to a network printer
  24. Tag helper not being processed in ASP.NET Core 2
  25. System.web.mvc missing
  26. How to convert DataTable to class Object?
  27. Can System.Web be used with ASP.Net Core with Full Framework
  28. How to implement Security Protocols TLS 1.2 in .Net 3.5 framework
  29. How to add smtp hotmail account to send mail
  30. Best way to restrict access by IP address?

Leave a Comment