Trigger a notification 3 days before the Planned End Date?

Rick54
Tera Expert

I am working on a scheduled job which send notification based on a 'Planned Start Date' field and it sends out notification 3 days before the date mentioned in the field. I am doing the below filter to use it in the scheduled job as encoded query but filter is not giving me any records back even though there are records exist. am I missing anything or is there any other way to achieve this? Thanks!

 

Field:

find_real_file.png

Filter:

find_real_file.png

1 ACCEPTED SOLUTION

You can use 2 conditions for at or after 3 days from now and at or before 4 days from now. That should give you the desired result.

-Anurag

View solution in original post

7 REPLIES 7

See if this thread helps.

https://community.servicenow.com/community?id=community_question&sys_id=ebf68a1cdbf5f388d82ffb2439961992

 

Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Vinod Kumar Kachineni
Community Rising Star 2022

You can use 2 conditions for at or after 3 days from now and at or before 4 days from now. That should give you the desired result.

-Anurag

Thanks for the reply. I tried the above approach but it was giving me records with 3 days and so but I need exactly 3 days ones.