Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Relative Query for 30 days ahead?

Elizabeth26
Tera Contributor

I am trying to write a query that will be for 30 days in the future.

So, for example, due date is 30 days from now

I tried this but it doesn't seem to work. I can only get it work for 30 days ago. Is there a way to get a query for 30 days in the future?

due_dateRELATIVEEE@dayofweek@ahead@30

1 ACCEPTED SOLUTION

Leo8
Mega Expert

Hi Elizabeth,

 

You can use "RELATIVEGT": due_dateRELATIVEGT@dayofweek@ahead@30

 

Maybe this may help:

https://docs.servicenow.com/bundle/paris-platform-user-interface/page/use/common-ui-elements/reference/r_OpAvailableFiltersQueries.html

 

Best regards,

Leo

View solution in original post

6 REPLIES 6

Yes Ankur. Do you have any suggestion?

asifnoor
Kilo Patron

Hi,

 

you can use like this  if you want to get next 30 days ahead.

find_real_file.png

Then the final filter will be like this.

find_real_file.png

Mark the comment as a correct answer and helpful if this helps.