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?
