Relative Operator in Filter Condition

Piyush Dwivedi
Tera Contributor

Hello,

Is with Relative Operator, if we select After or Before so does it mean by default gives filter conditions as (on or before) & (on or after)

 

If not, then please guide how we can achieve this (on or before) & (on or after)

1 ACCEPTED SOLUTION

DrAtulGLNG_0-1750759465783.png

 

 

@NeethuB 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

12 REPLIES 12

Vishal Jaswal
Giga Sage
Giga Sage

Hello @Piyush Dwivedi 

Use "trend" instead of relative:

VishalJaswal_0-1750190043012.png

 


Hope that helps!

@Vishal Jaswal Thanks for response.

I want to filter Problem Ticket which are 30 days or older aged.

Ankur Bawiskar
Tera Patron
Tera Patron

@Piyush Dwivedi 

for your requirement -> I want to filter Problem Ticket which are 30 days or older aged.

Do this

1) Opened [on or before] 30 days ago

OR

2) Opened [Before] 31 days ago

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Is Relative operator doesn't give by default (on or before) for before selection?