Weeknumber in a querry

[Jack Daniels]

Hi !
I am running a querry that let the user choose year like Year:Year(Date) and then [What year do u want?]
and it works fine.

Then I want the querry to ask for the weeknumber, but how do i write this?
Is it possible?

I tried Weeknumber: Weeknunber(date) but it doesn't work

Anyone know?

Jack

 

[sfreeman@co.mer]

Did you look at the DatePart function?