Filtering on Date in Database View

Renee-17
Tera Guru

How do I specify a where clause in the database view that says where

 

  • xyz_sys_created_on less than 3 months ago

xyz is the table prefix.

1 ACCEPTED SOLUTION

SanjivMeher
Kilo Patron
Kilo Patron

This thread may help 

https://www.servicenow.com/community/developer-forum/database-view-date-parameter/m-p/1417336

 

The other option is create a database view and then add filter to your report created on database view to get the last 3 months data.


Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

1 REPLY 1

SanjivMeher
Kilo Patron
Kilo Patron

This thread may help 

https://www.servicenow.com/community/developer-forum/database-view-date-parameter/m-p/1417336

 

The other option is create a database view and then add filter to your report created on database view to get the last 3 months data.


Please mark this response as correct or helpful if it assisted you with your question.