
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2019 07:57 AM
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:
Filter:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2019 08:47 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2019 08:02 AM
Hi Rick,
This filter is probably looking for the changes where planned start date is EXACTLY 3 days before from now, that is why you are not getting any records, if you change the filter to 'at or before' then you will get the records, but i guess that is not going to solve your actual ask.
I think to send a notification 3 days before the planned start date you can edit the workflow and code it in there using timers/wait for condition.
-Anurag

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2019 08:06 AM
Thanks for the reply Anurag. I just want the records with exact 3 days.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2019 08:40 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-31-2019 10:24 AM
Thanks for the reply. I tried this approach but it was giving me records with 3 days and so but I need exactly 3 days ones.