get count iof an offer which is used multiple times in offer on basis of created_at in laravel code example

Example 1: laravel where creation is today carbon

$posts = Post::whereDate('created_at', Carbon::today())->get();

Example 2: where('created_at', '=', date('Y-m-d'));

$q->where(DB::raw("DATE(created_at) = '".date('Y-m-d')."'"));