We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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.