Number of week

  • Thread starter Thread starter Hallgeir
  • Start date Start date
H

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
 
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
Click to expand...

DatePart("ww",[DateField])
or ..
Format([DateField],"ww")
 
Thank you!
I have used the Datepart function many times but I just did not see that
solution i this case.

Hallgeir
 
Back
Top