DatePart returning week

[Guest]

I have used DatePart to change date to week. Week starts on Monday and first
week of 2004=1

DatePart("ww";[Date];2;1)

But now I have a problem when 2004 turns into 2005 - first week in 2005 is 53.

If I don't do anything I get the wrong weeknumber for 2005. If I change
first week to 53 I get an error message.

Anyone knows how to solve this? I use Access 2000.

 

[JohnFol]

Could you post the [Date] you are using as the followign returns 1 and not
53

DatePart("ww", #01/01/2005#,2,1)

 

[Van T. Dinh]

The result is different depending on how you define the "First Week of the
Year". Check Access VB Help for different options for the 4th argument
(FirstWeekOfYear) of the DatePart function.

HTH
Van T. Dinh
MVP (Access)