I want to build a view that will return records older than thirty days. I have built a view using "WHERE table.field < dateadd(day, -30, getdate())" 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!