The CreatorCon Call for Content is officially open! Get started here.

Help with Date Range options in Reports

rhiannon
Kilo Contributor

Hi,

I am looking for some help with adding in a date range option in reports.

find_real_file.png

I've had a request to add last 14 days into the above list but i don't seem to be able to find where this list of today, tomorrow, last week etc is defined. Does anyone has any ideas?

Thanks for any help.

Regards

Rhiannon

3 REPLIES 3

Robert Ninness
ServiceNow Employee
ServiceNow Employee

Hi Rhiannon,



For anything not in the default list of time operators, you can always use the relative option:


New report _ ServiceNow 2016-05-26 12-13-32.png


As far as I'm aware, there isn't any way to add operators to that list. Sorry!



Hope this helps,



~Robert


Thanks for your help Robert.



I was aware of the relative option but wanted to check there was no way i could add it to the list. I must admit i had hunted to see if there was a way before posting the questions so you've confirmed my suspicions really.



Thanks again


Arnoud Kooi
ServiceNow Employee
ServiceNow Employee

I was searching for the same and found it is defined in a Business Rule: "Get Date Filter Options for Date Filters"


But this seems to only be used in interactive filters.


It does not display in a normal list, i guess this is hardcoded in a not editable js file   /scripts/doctype/js_includes_doctype.js


find_real_file.png