I am trying to create a having statement but can't do it. I want to check if a members memdate is between two set dates.

m.sqlstr = "member.memdate >= 04/01/ + alltrim(str((year(date())-1)))) "
m.sqlstr = m.sqlstr + " and member.memdate >= 03/31/ + alltrim(str((year(date())))))"

I keep getting an error that says command contains unrecognized phrase or keyword. What am I doing wrong here? I can't get the syntax correct for sqlstr

Thanks,
Tyler