Create Report with Dynamic Filter Dates

[Saravana3]

Hi Mates, I want to a run a report in incident table.It should return all matching values from last 2 weeks ( Like Sunday to Sunday ). Any suggestion ? Thanks in advance. 

[SwarnadeepNandy]

Hello @Saravana3 ,

There are different ways to create a report in ServiceNow, depending on the type, source, and format of the report. However, one common way to create a report is to use the Report Designer tool, which allows you to create and customize reports using a graphical interface. You can access the Report Designer by typing “report designer” in the filter navigator and clicking ...

To create a report in the incident table that shows all matching values from the last 2 weeks, you can follow these steps:

• In the Report Designer, click Create New and select List as the type of report.
• In the Data tab, select Incident [incident] as the data source.
• In the Filter tab, click Add Filter Condition and select Created as the field, relative as the operator, on or after as the condition, 2 as the value, and Weeks as the unit. This will filter the incidents that were created on or after 2 weeks ago.
• In the Group by tab, you can optionally select a field to group the incidents by, such as Assignment group or State.
• In the Style tab, you can optionally change the appearance of the report, such as the color, layout, or pagination.
• In the Title tab, you can enter a name and a description for your report, such as “Incidents from last 2 weeks”.
• Click Run to preview your report and see the results. You can also click Save to save your report for future use.

I hope this helps you with your report creation. 

Kind Regards,

Swarnadeep Nandy

[Saravana3]

Hi Swarnadeep, Thanks for your reply. I don't find on or before/on or after in date filter. There is only before/after option and there is no Weeks unit. 

[SwarnadeepNandy]

Hi @Saravana3 ,

Try something like this maybe.

Kind Regards,

Swarnadeep Nandy

[ctoyer]

Am I incorrect that the relative days operation will query to the exact 24 hour mark backwards from the time you are running the query?  Meaning if I run this on a Wednesday, I won't get Monday to Sunday 2 weeks ago, but instead will get a 2 week span beginning at this exact time, two Wednesdays ago?

Curious if anyone knows how to query this scenario:

I pull a report for every week (I'll call them ServiceNow weeks, Mon thru Sun).  Let's say I pull it at some point on Monday and use 'Created Last Week'.  I can run the report on any day this week and I'll get the same Monday to Sunday data.    The relative 'days ago' query starts from right now and works itself backwards.

It seems there's no "Created 2 weeks ago", which would pull entries created during the period 2 ServiceNow weeks ago.   And by extension, no Created After 2 weeks ago, which would give the OP his last 2 ServiceNow weeks of data (rather than last 14 days of data, which would only be perfect if run at 12AM Monday morning).

I assume the answer is some tricky scripting, no?