Will try to clarify it a bit further. Offhand you could probably do something like the following to find if it fell within some week range: created_at BETWEEN

Will try to clarify it a bit further. Offhand you could probably do something like the following to find if it fell within some week range: created_at BETWEEN (date_trunc('week', now())) AND (date_trunc('week', now() - '1 week'::interval))