What about
...
WHERE today_date BETWEEN week_start AND week_end
Now these are three values that you require to use; today_date is the date that
you want to check, and week_start and week_end are values for the dates or
the range you want to check within. They can be columns, parameters or other hard-coded values. They depend on how you want to use. Anyways, the overall general solution is that you need to use
WHERE[
^] clause and
BETWEEN and AND[
^] operators to check whether a variable is
within this range.