[vicsireland] DatePart function in SQL

Hi folks!
Can someone help me with the syntax for DatePart in a where clause? Just
like "where f1 = date()". But in stead of using the current date as a
filter criteria, I want to use the current week. 
I can use DatePart as an argument to format date fields into calendar
weeks, but I can't make it work as a function of its own. Any
suggestions?
Cheers,
Robbie

Other related posts: