How to get last day of a month?

@vincentmimounprat99

There are many ways to do that. Since you are using Laravel, you can easily use ->endOfMonth() of Carbon for that.

For example

now()->endOfMonth()

It will return you the last day of the current month.

@tisuchi as per instruction my query should work. but it is not working. here is my code

Scholarship::where('expired_at', '>', now()->endOfMonth())
	->orderBy('count', 'desc')
	->get();

And I want to get 10 records only.

@vincentmimounprat99 you have to use

Scholarship::whereDate('expired_at', '>', now()->endOfMonth())
    ->orderBy('count', 'desc')
    ->limit(10)
    ->get();

@vincentmimounprat99

To achieve your goal, you need to change your code as follows-

Scholarship::where('expired_at', '>', now()->endOfMonth())
	->orderBy('count', 'desc')
	->take(10)
	->get();

Thank you both of you @laracoft @tisuchi

Carbon::now()->endOfMonth()

Added class carbon

Carbon must added first Carbon::now()->endOfMonth()