in reply to Re^3: For a better efficiency and speed question!
in thread For a better efficiency and speed question!

AND ((date + 125 DAYS) < CURRENT_DATE)

The same as this but more easy to calculate

AND ((date + 1 YEAR) < (CURRENT_DATE + 240 DAYS) )

In Section Seekers of Perl Wisdom