2008/11/13 Duckster101 <[EMAIL PROTECTED]>:
>
> I am trying to use the DatePart function to return the week number for
> a specific date. I have been having difficulty getting it to return
> the correct week number.
>
> When I use the DatePart function using all the same parameters except
> the date, the function returns different results.
>
> For example:
>
> DatePart(DateInterval.WeekOfYear, CType("12/29/08", Date),
> FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFourDays)
> Returns 53
>
> DatePart(DateInterval.WeekOfYear, CType("1/3/09", Date),
> FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFourDays)
> Returns 52
>
> As you can see, the only thing different between these two functions
> is the date that is passed. Both of these dates fall within the same
> week, so why the difference in what it returns?
>
Looks like you found a bug. Although, with all the different locale
settings, one never knows if this is some sort of environmental issue.
