- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2024 02:58 PM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2024 03:09 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2024 03:09 PM
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.