You will need curly brackets ({}) around the date. To that matter, it would be better to format the date using:

{^yyyy-mm-dd} - this way if somebody changes the "SET DATE" you won't get hosed...

>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