Thanks Joseph,

That got rid of my error but I can't get the results that I need. It doesn't seem like my string is doing what I need it to do.

Here are my strings.

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


If the date falls between April 1, 1999 and March 31, 2000 print them. But if I have a date that is March 31, 1999 it picks it up and prints it. Where is my logic wrong?

Tyler