Number of week

[Hallgeir]

I tought this would be easy but I can't find the answer. I'm looking for a
function, that I can use in my querie, that will return the number of the
week of a given date. I tried Week(mydate) but that was not the solution. I
hope someone can give me a hint.

Thanks
Hallgeir

 

[fredg]

I tought this would be easy but I can't find the answer. I'm looking for a
function, that I can use in my querie, that will return the number of the
week of a given date. I tried Week(mydate) but that was not the solution. I
hope someone can give me a hint.

Thanks
Hallgeir

DatePart("ww",[DateField])
or ..
Format([DateField],"ww")

 

[Hallgeir]

Thank you!
I have used the Datepart function many times but I just did not see that
solution i this case.

Hallgeir