🚀 go-pugleaf

I have had trouble with the following code.  I can't seem to pass a
variable into an Extract statement.  Any help in getting dates out of
the table would be appreciated.  Things like birthdays which you only
want to enter once but come around every year..

select  name, reminder, event, eventdate, comment
from Grandma
where reminder<=:Reminder
and eventdate>=:Eventdate
or
event="Birthday"
and
(EXTRACT(Month from reminder) <=Extract(Month from :Reminder))
and
(EXTRACT(Month from eventdate) >= Extract(Month from :Eventday))
and...