How can I write a query to draw records from a DB where the field "StartDate" is in a specific week
<cfquery name="getWeekRows" datasource="ksw">
SELECT * FROM Events
Where StartDate = ?
Missing is the expression [?] to get the events where event startdate falls within a week 1 - 52.
Hope someone can help me!