This is a SQL issue, not a Perl one. What RDBMS are you using?
The comparison doesn't look right here. You have a DATEADD (which may or may not exist, you need to clarify the db you are using and give us the error), but you aren't comparing to anything. In the middle of the where you'd have a simple date; perhaps you intend to compare that to something?
Also, in the future please select a more suitable title for the thread.