DatePart returning week

[Ã…sa]

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)