Database View - Where Clause

Mark36
Kilo Explorer

Does anyone know the script to filter on records created 90 days or 3 months ago within the Where Clause of a Table within a Database View?

Below is the javascript command I have applied but this does not work. Note 'sa_timestamp' is the field that displays the date I want to filter on.

sa_timestamp>=javascript:gs.beginningOfLast90Days()

7 REPLIES 7

Hi Mark,

Did you find anything useful for this anywhere so that you can share here?

Regards

Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Mark,

Any update on this?
Can you mark my answer as correct, 👍 helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

If we have huge data more 25 lakh then this reporting filter is not working. that Why I am looking for date filter in database view