Try putting the date as,
CDate("29-Dec-2008") and CDate("3-Jan-2009")
On my system I have results 53 and 1
My Regional Settings = English (United States)
Note that always use 'Month Name' (instead of Month Number) in the
Date string. This removes the chances of incorrect conversion of date,
since different users have different Regional Settings.
On Nov 13, 9:49 pm, Duckster101 <[EMAIL PROTECTED]>
wrote:
> 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?
