Create new value at date format filter

[Reporting Team]

Hello Community,

I need to create a report that filters by date filter that it isn't defined OOB. I need  a report that shows items created between last and next Wednesday.

Any help about it? I attach an screenshot to exply my need:

Thanks!

[Tsura Andreeva]

Take a look at this article going over Custom Interactive Filters:

https://community.servicenow.com/community?id=community_question&sys_id=c11907e1db5cdbc01dcaf3231f961912

[Reporting Team]

One question about custom interactive filters: is needed to include teh report in a dashbaord to use it?

Is there anyway to apply a filter date like'between las/next week's day (Wednesday) when you define a report? I would need to have the operand last/next week's day when I use operator between (at or after,...). I don't know if there is anyway to obatin it, I don't know where the operands definde at Servicenow are defined.

Do you know?

[Aman Kumar S]

You will need to create custom interactive filters.

Follow below link to understand and create one

Create a dynamic filter option

You will basically need to do some scripting to get the result

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[Reporting Team]

I think that in this case, I can't use dynamic filter option... Doesn't it?

I read that : "dynamic filter operator is only available for Reference fields. Date/Time fields are not reference fields, the dynamic filter operator will not be available."

Thanks!