Addition report ranges

Davie · ‎07-03-2020

If reporting or filtering on record say by created by and selecting ON 'Last 3 months' we get the correct records returned but can we add other options such as:
'Last 4 Months'
'Last 5 Months'
'Last 7 Months'
'Last 8 Months'
'Last 10 Months'
'Last 11 Months'

we have some rolling reports to get these type of time frames but currently have to amend the reports each month to specify the date ranges and this is not sustainable

I found a ui script called 'getDaysAgoByDay' and tried amending that but without joy

Davie · ‎07-06-2020

and just close this loop off as we can't have what i was looking for, enhancement idea raised btw, i have rejigged my reports so they are a little easier to update monthly.

I've gone with the created TREND then the month

AND a created in Last 6 months line

so it give me same data as specific dates and a whole months data regardless of when in the following months I am. And now all i have to do monthly is month trend month on one month so a lot simpler then adding in relative dates 🙂

View solution in original post

Jaspal Singh · ‎07-03-2020

Hi Davie,

Seems this is duplicate thread of https://community.servicenow.com/community?id=community_question&sys_id=45b54ad9db3590145129a851ca96.... Kindly avoid duplicating threads for similar issues.

Davie · ‎07-03-2020

no probs, was just trying to find a solution and thought people look at answer questions by the categorization of the question

Jaspal Singh · ‎07-04-2020

Replied to original thread.

Adam Stout · ‎07-04-2020

I would just use the relative operator which gives you a lot of flexibility.