I want to build a view that will return records older than thirty days. I have built a view using &#34;WHERE table.field < dateadd(day, -30, getdate())&#34; but it just returns every row in the table. Is it not possible to do this in SYBASE? DB version is 11.0.3.3.

Thanks!