I have the need to find records where the expiration date is after the end of next year and the expiration date month is less than this month.
I can use
$sugarQuery->where()->gt('expiration_date', $next_year_end)
but how can I check for the month?
Am I stuck with a SQL query or can I leverage SugarQuery somehow?
Thanks,
Francesca