Click here to Skip to main content
15,915,750 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: get number of weeks from given year Pin
originSH4-Jan-08 2:24
originSH4-Jan-08 2:24 
GeneralRe: get number of weeks from given year Pin
Tom Deketelaere4-Jan-08 2:58
professionalTom Deketelaere4-Jan-08 2:58 
GeneralRe: get number of weeks from given year Pin
originSH4-Jan-08 3:09
originSH4-Jan-08 3:09 
GeneralRe: get number of weeks from given year Pin
Tom Deketelaere4-Jan-08 5:10
professionalTom Deketelaere4-Jan-08 5:10 
GeneralRe: get number of weeks from given year Pin
originSH4-Jan-08 5:29
originSH4-Jan-08 5:29 
GeneralRe: get number of weeks from given year Pin
Thomas Krojer7-Jan-08 1:25
Thomas Krojer7-Jan-08 1:25 
GeneralRe: get number of weeks from given year Pin
Tom Deketelaere7-Jan-08 1:37
professionalTom Deketelaere7-Jan-08 1:37 
GeneralRe: get number of weeks from given year Pin
Thomas Krojer7-Jan-08 2:31
Thomas Krojer7-Jan-08 2:31 
my hint was 365 and 366, not your 364 and 365 day ...


<br />
    Private Function  Weeknumber_Entire4DayWeekRule(ByVal inDate As  DateTime) As Integer<br />
        Const JAN As Integer = 1<br />
        Const DEC As Integer = 12<br />
        Const LASTDAYOFDEC As Integer = 31<br />
        Const FIRSTDAYOFJAN As Integer = 1<br />
        Const THURSDAY As Integer = 4<br />
        Dim ThursdayFlag As Boolean = False<br />
<br />
        ' Get the day number since the beginning of the year<br />
        Dim DayOfYear As Integer = inDate.DayOfYear<br />
<br />
        ' Get the numeric weekday of the first day of the<br />
        ' year (using sunday as FirstDay)<br />
        Dim StartWeekDayOfYear As Integer = _<br />
           DirectCast(New DateTime(inDate.Year, JAN, FIRSTDAYOFJAN).DayOfWeek, Integer)<br />
        Dim EndWeekDayOfYear As Integer = _<br />
            DirectCast(New DateTime(inDate.Year, DEC, LASTDAYOFDEC).DayOfWeek, Integer)<br />
<br />
        ' Compensate for the fact that we are using monday<br />
        ' as the first day of the week<br />
        If StartWeekDayOfYear = 0 Then<br />
            StartWeekDayOfYear = 7<br />
        End If<br />
        If EndWeekDayOfYear = 0 Then<br />
            EndWeekDayOfYear = 7<br />
        End If<br />
<br />
        ' Calculate the number of days in the first and last week<br />
        Dim DaysInFirstWeek As Integer = 8 - StartWeekDayOfYear<br />
        Dim DaysInLastWeek As Integer = 8 - EndWeekDayOfYear<br />
<br />
       ' If the year either starts or ends on a thursday it will have a 53rd week<br />
        If StartWeekDayOfYear = THURSDAY OrElse EndWeekDayOfYear = THURSDAY Then<br />
            ThursdayFlag = True<br />
       End If<br />
<br />
        ' We begin by calculating the number of FULL weeks between the start of the year and<br />
        ' our date. The number is rounded up, so the smallest possible value is 0.<br />
        Dim FullWeeks As Integer = _<br />
            CType(Math.Ceiling((DayOfYear - DaysInFirstWeek) / 7), Integer)<br />
 <br />
        Dim WeekNumber As Integer = FullWeeks<br />
<br />
        ' If the first week of the year has at least four days, then the actual week number for our date<br />
        ' can be incremented by one.<br />
       If DaysInFirstWeek >= THURSDAY Then<br />
            WeekNumber = WeekNumber + 1<br />
        End If<br />
<br />
       ' If week number is larger than week 52 (and the year doesn't either start or end on a thursday)<br />
        ' then the correct week number is 1.<br />
       If WeekNumber > 52 AndAlso Not ThursdayFlag Then<br />
            WeekNumber = 1<br />
        End If<br />
<br />
        'If week number is still 0, it means that we are trying to evaluate the week number for a<br />
        'week that belongs in the previous year (since that week has 3 days or less in our date's year).<br />
        'We therefore make a recursive call using the last day of the previous year.<br />
        If WeekNumber = 0 Then<br />
            WeekNumber = Weeknumber_Entire4DayWeekRule( _<br />
                New DateTime(inDate.Year - 1, DEC, LASTDAYOFDEC))<br />
        End If<br />
        Return WeekNumber<br />
    End Function


i found this with google: "week number vb.net"
GeneralRe: get number of weeks from given year Pin
ChandraRam4-Jan-08 1:07
ChandraRam4-Jan-08 1:07 
GeneralRe: get number of weeks from given year Pin
Tom Deketelaere4-Jan-08 1:23
professionalTom Deketelaere4-Jan-08 1:23 
GeneralRe: get number of weeks from given year Pin
ChandraRam4-Jan-08 1:36
ChandraRam4-Jan-08 1:36 
GeneralRe: get number of weeks from given year Pin
Tom Deketelaere4-Jan-08 2:08
professionalTom Deketelaere4-Jan-08 2:08 
Question'Charset' is not accessible in this context because it is private. Pin
Hemesh3-Jan-08 22:59
Hemesh3-Jan-08 22:59 
GeneralRe: 'Charset' is not accessible in this context because it is private. Pin
Dave Kreskowiak4-Jan-08 4:25
mveDave Kreskowiak4-Jan-08 4:25 
GeneralRe: 'Charset' is not accessible in this context because it is private. Pin
Hemesh7-Jan-08 22:55
Hemesh7-Jan-08 22:55 
GeneralDate Time value Pin
BOREC3-Jan-08 22:38
BOREC3-Jan-08 22:38 
GeneralRe: Date Time value Pin
BOREC3-Jan-08 23:57
BOREC3-Jan-08 23:57 
QuestionRe: Date Time value Pin
tellytub5-Jan-08 20:15
tellytub5-Jan-08 20:15 
GeneralRe: Date Time value Pin
infotools4-Jan-08 20:26
infotools4-Jan-08 20:26 
GeneralPlease help me convert this VBS to VB.NET code. I want to try and figure out if this is the problem in my ssis package. [modified] Pin
Support1233-Jan-08 21:43
Support1233-Jan-08 21:43 
GeneralWebbrowser Control Plz Help Pin
King of Kingz3-Jan-08 21:28
King of Kingz3-Jan-08 21:28 
GeneralRe: Webbrowser Control Plz Help Pin
Christian Graus3-Jan-08 23:44
protectorChristian Graus3-Jan-08 23:44 
QuestionHow can I communicate with an sd card ? Pin
Big Ralph3-Jan-08 21:27
Big Ralph3-Jan-08 21:27 
AnswerRe: How can I communicate with an sd card ? Pin
nishkarsh_k3-Jan-08 22:02
nishkarsh_k3-Jan-08 22:02 
GeneralRe: How can I communicate with an sd card ? Pin
Big Ralph3-Jan-08 22:04
Big Ralph3-Jan-08 22:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.