• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Get Week # between two dates

Get Week # between two dates
DateTime d1;
DateTime d2;
DateTime d3;
 
d1=DateTime.Parse("04/01/09");
d2=DateTime.Parse("09/01/09");
d3=DateTime.Now;                      //e.g 05/19/09  
 
d3= what week # between d1 and d2 ???
 
URGENT.

Open in new window

0
gazens
Asked:
gazens
  • 3
  • 3
  • 3
1 Solution
 
kyleroiCommented:
Are you looking for numbers between the two dates or a date?  I am confused on what your trying to do.
0
 
tcullerCommented:
Week number as in, the first week of January is week one, and the last week of December is week 52? Or do you mean just how many weeks are between two given dates?
0
 
gazensAuthor Commented:
If I select current date i.e 05/19/2009. So between 1 to 52 weeks in a year what is the position of currentdate?  Is that good enough? Thanks.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
tcullerCommented:
I guess that'll work, though I don't see the point of the other two dates there. This should be fairly simple:


public System.Int32 GetWeekNumber(System.DateTime myDate)
{
     System.Int32 weekNumber = myDate.DayOfYear / 7
     return (weekNumber == 0) ? weekNumber + 1 : weekNumber;
}

Open in new window

0
 
kyleroiCommented:
public Int32 WeekOfYear(DateTime dtInput)
        {
            DateTime d1 = new DateTime(dtInput.Year, 01, 01);
            Int32 nCt = d1.DayOfWeek == DayOfWeek.Sunday ? 0 : 1;
            Boolean blFnd = false;
            while (d1.Year == dtInput.Year && blFnd == false)
            {
                if (d1.DayOfWeek == DayOfWeek.Sunday)
                {
                    nCt++;
                }
                if (d1.Date == dtInput.Date )
                {
                    blFnd = true;
                }
                else
                {
                    d1 = d1.AddDays(1);
                }
            }
            return nCt;
        }
0
 
gazensAuthor Commented:
This is good enough.
0
 
kyleroiCommented:
The accepted solution may not be accurate as the first week of any given year does not always have 7 days.   For example the first week this year only had 4 days.  Todays date is in the 21st calander week of the year but there has only been 19 full 7 day weeks.  

I guess it depends on what you are looking for.... good luck.
0
 
gazensAuthor Commented:
According to you : If I use your solution then its ok at the begining but when I put 12/28/09  then its shows 53 week is that true??
0
 
tcullerCommented:
The System.DateTime object should take care of any inconsistencies like that. Try the following code, for example; it even takes care of leap years and such. If I am wrong, and this solution isn't exactly what you're looking for, let me know.
for (int i = 1990; i < 2010; i++)
{
     Console.WriteLine("DayOfYear: {0}", new DateTime(i, 12, 30).DayOfYear);
}

Open in new window

0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 3
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now