Adding a Date Parameter using Where Clause in Database View

[Kathrina Yvonne]

Hi, I'm having trouble adding a date parameter using the Where Clause in Database View. 

'Resolved tickets from last month'

I'm quite new to ServiceNow so hoping someone could help. Thanks a lot!

I tried using this (see attached photo below), but I keep getting this error message "Where clause in view u_resolved_incidents_report has an invalid field or a field that is not visible (DATE_SUB)"

[Mark Manders]

What are you trying to do? It looks like it would be easier to just create the DB view and create your report on that, instead of putting all kinds of filters in the DB view itself.