How to calculate how many users were created for the current and last week, but the week is from Sunday to Sunday?

Question

Laravel

Good afternoon. I made it to count for the current week like this:

$current_week = User::whereDate('created_at', '>=', date('Y-m-d H:i:s', strtotime('-7 days')))->count();

And for the past:

$previous_week = User::whereDate('created_at', '<', date('Y-m-d H:i:s', strtotime('-7 days')))
            ->whereDate('created_at', '>=', date('Y-m-d H:i:s', strtotime('-14 days')))->count();

It turns out this doesn't quite fit. It is necessary that the current week is considered from today and back to Sunday, and the past from this Sunday and even before Sunday back. How to do it?

Answer 1

Use Carbon methods in queries with created_at. An example of how to subtract weeks I wrote to you a week ago.