How to find number of weeks

Question

0.00/5 (No votes)

See more:

Hi,

How to find number of weeks for between two different years. the value should be display in dropdown in asp.net.

pls. help.

Regards,
Ganesh.S

Posted 24-Jun-11 4:03am

gani7787

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Answer 1 · 2011-06-24T04:10:00

Solution 1

DateTime oldDate = new DateTime(2002,7,15);
DateTime newDate = DateTime.Now;

// Difference in days, hours, and minutes.
TimeSpan ts = newDate - oldDate;

Then you can use the properties on TimeSpan to get the relevant information

http://msdn.microsoft.com/en-us/library/system.timespan.aspx[^]

C#

public static int NumberOfWeeks(DateTime dateFrom, DateTime dateTo)
{
   TimeSpan Span = dateTo.Subtract(dateFrom);
   if (Span.Days <= 7)
   {
      if (dateFrom.DayOfWeek > dateTo.DayOfWeek)
      {
         return 2;
      }
      return 1;
   }
   int Days = Span.Days - 7 + (int)dateFrom.DayOfWeek;
   int WeekCount = 1;
   int DayCount = 0;
   for (WeekCount = 1; DayCount < Days; WeekCount++)
   {
      DayCount += 7;
   }
   return WeekCount;
}

That code was from http://madskristensen.net/post/Working-with-weeks-in-C-not-that-obvious.aspx[^]

Posted 24-Jun-11 4:10am

Dylan Morley

Comments

gani7787 24-Jun-11 10:14am

can you pls. provide vb.net code. so that it will be helpful for me...

Thanks..

Dylan Morley 24-Jun-11 10:15am

No sorry, you can do that yourself - show a little initiative ;)

fjdiewornncalwe 24-Jun-11 10:55am

Converting the code from C# into VB.NET is quite simple, especially for this example. Have a go at it and if you have issues relating to that translation, ask away and we'll be glad to help. Code translation like this is a great way for students to learn some of the ins and outs of a language. Do it and you will be amazed at how much a simple assignment like this can teach you.

thatraja 24-Jun-11 11:12am

Convert the code yourself. Here you go. C#.NET to VB.NET

fjdiewornncalwe 24-Jun-11 10:53am

Excellent answer. +5.
(I wish I could give you another +5 for the "you can do that yourself" comment). I appreciate it when the initiative is placed on the OP.

thatraja 24-Jun-11 11:11am

Nice answer. 5!

#realJSOP 24-Jun-11 11:34am

My version of your NumberOfWeeks method is only 2 lines (three if you want partial weeks), and it doesn't matter what order you pass in the dates. :)

Uday P.Singh 24-Jun-11 11:34am

good one my 5!!

#realJSOP · Answer 2 · 2011-06-24T05:16:00

C#

public int NumberOfWeeks()
{
    int days = Math.Abs((d1.Date - d2.Date).Days) + 1;
    weeks = ((int)Math.Floor((decimal)days / 7));
    // if you want partial weeks added to it, add this line:
    weeks += (((decimal)days % 7) > 0) ? 1 : 0;
    return weeks;
}

EDIT ===============

Since you seem to be incabpable of converting simple code to VB, here it is:

VB

public Function NumberOfWeeks() As Integer
    Dim days As Integer = Math.Abs((d1.Date - d2.Date).Days) + 1
    Dim weeks As Integer = CType(Math.Floor((decimal)days / 7)), Integer)
    ' if you want partial weeks added to it, add this line:
    If ((decimal)days Mod 7) > 0) Then
       weeks += 1
    End If
    Return weeks
End Function

Vivek Krishnamurthy · Answer 3 · 2011-06-24T04:45:00

Solution 2

This need not be done in vb.net code. I think this calculation is best done at javascript. This can be done on a client side event based on your design.

C#

var date1 = new Date(parm1);
var date2 = new Date();
var weeks = (date2-date1)/(1000*60*60*24*7).toFixed(2);

Posted 24-Jun-11 4:45am

Vivek Krishnamurthy

Jani Giannoudis · Answer 4 · 2011-06-26T10:57:00

You can use the class Week of the Time Period Library for .NET[^]:

C#

public int GetWeekOfYear( int year )
{
  return new Week( new DateTime( year, 12, 31 ) ).WeekOfYear;
} // GetWeekOfYear

Please note that Calendar.GetWeekOfYear does not calculate the week numbers according the ISO 8601 standard.