Laravel using carbon to get current quarter

php laravel laravel-5 php-carbon
imperium2335 picture imperium2335 · Apr 6, 2015 · Viewed 8.8k times · Source

How can I use Carbon to determine the current quarter? I.e. I would like to get hold of the date when the quarter started and the date when it ends.

I tried the intuitive echo new Carbon('this quarter'); way which doesn't work, but I guess they don't have one for quarters.

I figured it out, I did:

$query->where(DB::raw('QUARTER(FT.created_at)'), Carbon::now()->quarter);
$query->where(DB::raw('YEAR(FT.created_at)'), '=', Carbon::now()->year);

But now I am struggling with how to get the start and end date of the last quarter.

Answer

user1669496 picture user1669496 · Apr 6, 2015

You can use the firstOfQuarter and lastOfQuarter methods for determining the beginning and end dates of a quarter...

$date = new \Carbon\Carbon('-3 months');
$firstOfQuarter = $date->firstOfQuarter();
$lastOfQuarter = $date->lastOfQuarter();

Related questions

Laravel 5 Carbon format datetime

I have an array that returns the following date time: $item['created_at'] => "2015-10-28 19:18:44" How do I change the date to M d Y format in Laravel using Carbon? Currently it returns with an error $suborder['payment_date'] = $…

Read More
How to get Current Timestamp from Carbon in Laravel 5

I want to get current timestamp in laravel 5 and I have done this- $current_time = Carbon\Carbon::now()->toDateTimeString(); I am getting eror- 'Carbon not found'- What can I do? Can anyone help, please?

Read More
Format Timezone for Carbon Date

I'm trying to set the timezone for a date in a Carbon object. It works fine locally but on my production box it keeps giving me Bad timezone error. I've tried: $date->setTimezone('7'); $date->setTimezone('+7…

Read More