Tyler,

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

Try at the command window first:

? {04/01/ +alltrim(str(year(date())-1))}

That evaluates to an empty date.

You need

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

to hardcode the date into the sqlstr. Better than that would be an unambiguous-format date:

m.sqlstr = "member.memdate >= {^" + alltrim(str(year(date())-1)) + "-04-01} "