Reporting Date filter : on - Last 5 months

[Ashvin1]

Hi,

I need to create report that pulled record for last 4 months & Last 5 months. is there any way to add this new value on Date filter that say like that

Created : on : Last 4 months.

As we aware out of the box : last 3 months, last 6 months and last 9 months is available.

Regards,

Ashvin

[Lena_Latham]

Unfortunately I'm not a developer, so I'm not sure how to add dropdown options.   But, maybe a more-detailed filter set would get you closer:

Created : Relative : On or After : 5 : Months : Ago

AND

Created : Before : This Month

[SeanM1]

Hi Ashwin,

You can add values to the fiter by updating the Report Ranges (need admin access)

Refer to the below wiki article for details:

Report Ranges - ServiceNow Wiki

[pvijaysen]

Hi Sean, I tried but option is not coming in report for Date filter and not able to add option for Last 4 Months, you can also verify, it's not working..

Module: Report

Table: Incident

Created ON "Last 4 Months"

Regards,

Vijay

[SeanM1]

With the table name and element choosen for 'Last 4 months' value report range you've just created, are they the same values that you are using in your report?

They have to be the same to see the new value you've created

[jkohli]

I found a Business Rule - 'Get Date Filter Options for Date Filters', displaying all the options in Date Filter, you can try that. Hope that helps.