how to add filter condition exactly after 30 days from todays date

Aishwarya20
Tera Contributor

Hi,

I want to write filter condition of date after 30 days from now, please help me.

1 ACCEPTED SOLUTION

Abhijit4
Mega Sage

Hi,

You can achieve it like below, the digit in the image is not clear, I have added it is 29 and 31. The logic here is "Due Date after 29 from today and before 31 days from now" which will give us records where due date is 30(after 29 and before 31 is 30) days.

find_real_file.png

Let me know if you have any further queries.

 

Please mark this as Correct or Helpful if it helps.

 

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

View solution in original post

24 REPLIES 24

Jaspal Singh
Mega Patron
Mega Patron

Try below filter

Replace Planned Start Date with your date field

find_real_file.png

It is not giving exact after 30 days, giving middle dates as well, I want exact after30 days

In that case just keep the 1st filter & change the 0 to 30 days & remove the 2nd filter

Did you try above?