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.