When dealing with timezones you're no longer querying just for a year, you have to consider the offset of the timezone and then query based on a datetime value.
I whipped up a laravel playground example to get you started: https://laravelplayground.com/#/snippets/47cf3775-877a-4a9e-92e5-f33f96442a26
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community