... between current date - 7 days and current date ...

now() = current date