Last WeekNumber

[phpatrick]

Hey,

In my query I have an expression that gives me the number of the week : [WEEK: DatePart("ww";[DAG];2)-1]

This query is feeding a report. This report should give me only the data from the last (recent) week.

The highest weeknumber is 37, how do I get this number in my SQL where clause ?

LAST or TOP ?

thanks

 

[Golom]

WHERE DatePart("ww",[DAG],2) > DatePart("ww",Date,2)- 1
  AND Year([DAG]) = Year(Date)

the "Year" stuff is just to ensure that you get records only from the current year.