Report Dynamic date

[parsameera123]

Hi Folks,

I have a requirement to show reports on the story table. Client wants to check how many stories have been opened for the last two/three/four month in terms of month. i.e today is 16th November 2023 so if he want to check for the last month which is from 1st of Oct till 31st oct which is quite achievable by giving the filter "ON Last Month" but what if he wants to check from last month to last month which is September (1st September till 31st September) Or August (1st August till 31st August) Or July (1st July till 31st July).

Note: Client always wants to check from first day of the month till last day of the month which he can choose of the month at his own

[Dr Atul G- LNG]

Hi @parsameera123 

If i understood correctly you can use Between operator to get the records like , but it will be static, like only the value you put it give results.

In other case, create a report and fetch all the record and them on Dashboard. On Dashboard add the interactive filters to get the results. 

https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/dashboards/task/t_AddIntFilte... 

https://www.youtube.com/watch?v=OirwryvgCrM

[Peter Bodelier]

Hi @parsameera123 

How about this:

You can choose any month of course 🙂